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 25 times
0
Ankit Bajpai
- 13,128
- 4
- 25
- 40
Ciasto piekarz
- 7,853
- 18
- 101
- 197
-
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