2、mysql数据库中是否存在某张表
1 SELECT table_name FROM information_schema.tables WHERE table_schema = ‘your_db_name‘ and table_name = ‘your_table_name‘
【原】MySQL实用SQL积累
标签：
【原】MySQL实用SQL积累
select COLUMN_NAME from information_schema.COLUMNS where table_name = ‘your_table_name‘ and table_schema = ‘your_db_name‘;