mysql取得一个表的列名
方法为:
DESCRIBE tb_nine_safety_info;
缩写为:
DESC tb_nine_safety_info;
----
SHOW COLUMNS FROM tb_nine_safety_info;
select COLUMN_NAME from information_schema.columns where table_name='tb_nine_safety_info'
select * from information_schema.columns where table_name='tb_nine_safety_info'
也可以实现相同的功能
mysql取得一个表的列名
最新推荐文章于 2022-07-13 11:02:42 发布