SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘表名’
例如:
SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘rooms_man’
结果如下:
SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘表名’
例如:
SELECT * FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=‘rooms_man’
结果如下: