SELECT * FROM 'Table name' ORDER BY 'Column name' DESC Limit 30
I'd like to turn the above query as many as the number of tables, and there are about 300 tables.
1/ The PD table contains the table names of NameData. SELECT * FROM "Table Name" ORDER BY High DESC Limit 30 I'd like to get the name data of the table name on the PD table one by one and arrange the Keys tables.
If it is impossible to do number 2/1, I would like to arrange all the tables in the Keys database without deciding the 'table name' as one.
3/ If you run it, the PD and Keys will come out separately It only says that there is at least a table called array1 in the 'table name'. Doesn't the query contain variables?
DB Browser for SQLite is in use.sqlite3 python
Maybe it should be this kind of development. I haven't tested this code, so please refer to it.
© 2022 pinfo. All rights reserved.