mysql查看表结构命令
desc 表名;
show columns from 表名;
describe 表名;
show create table 表名;
use information_schema
select * from columns where table_name="表名";
show databas
执行如下sql：
sp_help tablename;
再如：
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = "APN_USER"
ORDER BY ORDINAL_POSITION
具体：
SELECT TABLE_NAME,COLUMN_NAME,DAT
