SELECT column_name AS 字段名 ,data_TYPE AS 类型,character_maximum_length AS 长度 ,is_nullable AS 是否为空,column_key AS 键 ,column_comment AS 注释,extra AS 自增 FROM information_schema.columns
WHERE table_schema='数据库' AND table_name='表名';
06-28
648
08-10
538
08-11
3万+