Generated a history list every day, the format is as follows, I want to export one of the data points one day all the data to a data point (1 min) is equivalent to 1440 points, I want to export the year now, how to use SQL statements one-time fix,
I can only think of stupid way, 365 tables, each lead a

CodePudding user response:

Build a new table, and the structure of these tables is consistent; Spell the name of the table and then use cycle, exec (" insert into... "); After the loop derived a new table,