SELECT
column_name,column_type,column_comment
FROM
information_schema.`COLUMNS`
WHERE
table_schema = 'tocc_om'
and table_name = 'ts_taxi_operation_grid_real_h'
order by ordinal_position
MySQL查看表字段信息
最新推荐文章于 2024-05-08 10:51:42 发布
该内容涉及SQL查询,用于从information_schema.COLUMNS获取特定数据库'tocc_om'中'ts_taxi_operation_grid_real_h'表的列名、列类型和列注释。查询结果按列序号排序。
摘要由CSDN通过智能技术生成