MySql 查看表信息与列信息

MySql
于泽  •  1541493045
MySql 查看表信息与列信息
SELECT *
FROM information_schema.`TABLES` a
WHERE a.TABLE_SCHEMA = 'database';

SELECT *
FROM information_schema.`COLUMNS` a
WHERE a.TABLE_SCHEMA = 'database';