摘要:MYSQL查询表结构1 show columns from 表名 (describe 表名);show full fields from `tsysmenu`// 比上面那个更全面SHOW FULL TABLES FROM `tjjsw` LIKE 't%'查询库中所有的表名2show create table 表名;//查建表语句use information_schemaselect * from columns where table_name='表名'/*this can see the table information*/show table sta
阅读全文