I want to select 2 columns from all the tables in database
select status, up_down_time
from all_tables
ORDER BY ID DESC LIMIT 1`
also I wondering if I can use show tables
Asked
Active
Viewed 21 times
0
Ankit Bajpai
- 11,992
- 4
- 23
- 40
Ciasto piekarz
- 7,175
- 13
- 72
- 173
-
I want to store store all tables in a variables – Ciasto piekarz Mar 01 '20 at 21:47
-
you can use a prepared statement where you select all tables SELECT table_name FROM information_schema.tables; and build a query that you execute. – nbk Mar 01 '20 at 21:50