SELECT * FROM information_schema.COLUMNS WHERE table_schema = ( SELECT DATABASE ( ) ) AND table_name = ( '表名' ) ORDER BY ordinal_position
MySQL-记录查询表字段的sql语句
最新推荐文章于 2023-08-24 18:29:11 发布
SELECT * FROM information_schema.COLUMNS WHERE table_schema = ( SELECT DATABASE ( ) ) AND table_name = ( '表名' ) ORDER BY ordinal_position