information_schema的結構

託帕發表於2018-07-26
ORM

select schema_name from information_schema.schemata;

select table_name from information_schema.schemata where table_schema = ‘zzcms’;

select column_name from information_schema.columns where table_schema = ‘zzcms’ and ‘table_name’ = ‘zzcms_zx’;

相關文章