how to show all table name mysql query
SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='database_name';
SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='database_name';
No comments:
Post a Comment