MySQL取数据库表，取数据表字段详解

来源：互联网发布：我要投诉淘宝小二编辑：程序博客网时间：2024/05/16 12:24

#取数据库所有表名#字段说明：#TABLE_SCHEMA 数据库名#TABLE_NAME 表名#TABLE_TYPE 表类型SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE FROM information_schema.`TABLES` WHERE TABLE_SCHEMA='database name' AND TABLE_TYPE='base table' ORDER BY TABLE_NAME;#取数据表所有字段#字段说明：#TABLE_SCHEMA 数据库名#TABLE_NAME 表名#COLUMN_NAME 字段名#ORDINAL_POSITION 字段序号#IS_NULLABLE 是否可为空#DATA_TYPE 字段类型#CHARACTER_MAXIMUM_LENGTH 字段长度#NUMERIC_PRECISION 字段数字位数(如:浮点型等)#NUMERIC_SCALE 字段数字小数位数(如:浮点型等)#CHARACTER_SET_NAME 字符集(如:utf8)#COLUMN_TYPE 字段类型详细(如:varchar(32))#COLUMN_KEY 字段是否keySELECT TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,IS_NULLABLE,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE,CHARACTER_SET_NAME,COLUMN_TYPE,COLUMN_KEY FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA='database name' AND TABLE_NAME='table name' ORDER BY ORDINAL_POSITION;

0 0