查询mysql数据库表结构及字段注释
SELECT column_name, column_comment, column_type, column_key
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = 'lift'
AND table_schema = 'pro_callcenter'
查询mysql数据库表结构及字段注释
最新推荐文章于 2024-05-21 18:24:03 发布
查询mysql数据库表结构及字段注释
SELECT column_name, column_comment, column_type, column_key
FROM INFORMATION_SCHEMA.Columns
WHERE table_name = 'lift'
AND table_schema = 'pro_callcenter'