首页 > 数据库 >MySql导出表结构并排序

MySql导出表结构并排序

时间:2023-02-22 15:13:09浏览次数:75  
标签:name column 导出 MySql table 排序 SELECT schema

SELECT
    column_name as 字段名称,
    column_type as 字段类型,
    column_comment  as 字段描述
FROM
    information_schema.COLUMNS 
WHERE
    table_schema = (
    SELECT DATABASE
    ()) 
    AND table_name = ('bdjk_station_skewing_visual')
ORDER BY
    ordinal_position

 

标签:name,column,导出,MySql,table,排序,SELECT,schema
From: https://www.cnblogs.com/2979100039-qq-con/p/17144393.html

相关文章