摘要：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 阅读全文