MySql导出表结构并排序

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

 

posted @ 2023-02-22 14:57  一生的风景  阅读(42)  评论(0编辑  收藏  举报