- 当前位置：首页 >IT科技类资讯 >取得MySQL表信息的语句
取得MySQL表信息的语句
发布时间：2025-11-04 14:31:25 来源：云智核 作者：域名
复制/*取得表信息*/ 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号-28sitemap