- 当前位置：首页 >域名 >取得MySQL表信息的语句
取得MySQL表信息的语句
发布时间：2025-11-04 19:25:26 来源：技术快报 作者：系统运维
复制/*取得表信息*/ select table_Comment as Script,信息 table_Name as TableName, 0 as id, Create_Time as createDate, CASE table_Type WHEN BASE TABLE then U when VIEW then V ELSE table_Type END as tableType, 0 as Category from tables; /*取得外键关系*/ SELECT CONSTRAINT_Name as Script, CONSTRAINT_Name as TableName, 0 as id, CURRENT_TIMESTAMP as createDate, CASE CONSTRAINT_TYPE WHEN FOREIGN KEY THEN F WHEN PRIMARY KEY THEN K ELSE CONSTRAINT_TYPE END AS tableType, 0 as Category From TABLE_CONSTRAINTS; SELECT Table_Name, Column_Name, Column_Type, Column_Key, Column_Comment From Columns ; /*取得列信息*/ select table_name as tablename, column_Name as columnName, column_type as columnType, 0 as columntypeindex, CHARACTER_OCTET_LENGTH as length, Numeric_Precision as decimaldigits, column_comment as Script,column_default as defaultvalue, is_nullable as isnullable, case extra when auto_increment then 1 else 0 end as IsMarking, 0 as colid, U as ObjectType, data_type from columns; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.
香港云服务器源码库服务器租用IT技术网企商汇益华科技IT资讯网亿华云源码下载益强智囊团益强前沿资讯益华IT技术论坛亿华智慧云思维库益强科技益强智未来益华科技多维IT资讯益华科技码力社科技前瞻极客编程创站工坊益强编程堂益强数据堂编程之道亿华互联亿华科技益强资讯优选技术快报极客码头益强编程舍运维纵横IT资讯网智能时代码上建站云站无忧汇智坊全栈开发益强IT技术网亿华云计算亿华云亿华智造
- Copyright © 2025 Powered by 取得MySQL表信息的语句,技术快报 滇ICP备2023006006号-46sitemap