How to change the default alias of a query and how to add queries in bulk when DataSource is mysql

[wypxl]

Hello everyone,
My grafana's dataSource is mysql, it stored the power consumption per minute of over 200 cabinets, so I used 'Time series' to display them, now I have two questions that I hope you can help me with.
1.The name displayed of the data taken out on the panel is the column name of the power_consumption by default. How can I change this name to the cabinet_id searched by sql statement?
2.Normally, one query must be added to each cabinet. Can I add more than 200 cabinets in batches?

The data format is as follows, hope can get help from here, thanks a lot

[charleskorn]

This repository is specifically for Mimir, but your question seems to be about Grafana and querying MySQL. Please post your question in the Grafana community forum for help with Grafana: https://community.grafana.com/c/support/33.

[wypxl]

OK，thanks~