如题
解决方案 »
- mySQL Cluster群集 application 连接问题
- ERROR 1030: Got error 127 from table handler
- mysql的存储过程执行的原理的问题?
- 慢查询的一个奇怪问题
- mysql-proxy版本问题
- 求一段mysql语句
- 问一下如何操作上亿条记录的表?
- 优化一个SQL语句
- jsp与MYSQL的连接问题
- 怎么用mysql把mdf和ldf文件打开啊啊啊啊,好苦恼啊
- com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
- 收藏 中文用户名登陆有误,字符编码问题,怎么弄?
The COLUMNS table provides information about columns in tables. INFORMATION_SCHEMA Name SHOW Name Res
TABLE_CATALOG NULL
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME Field
ORDINAL_POSITION see notes
COLUMN_DEFAULT Default
IS_NULLABLE Null
DATA_TYPE Type
CHARACTER_MAXIMUM_LENGTH Type
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION Type
NUMERIC_SCALE Type
CHARACTER_SET_NAME
COLLATION_NAME Collation
COLUMN_TYPE Type MySQL extension
COLUMN_KEY Key MySQL extension
EXTRA Extra MySQL extension
PRIVILEGES Privileges MySQL extension
COLUMN_COMMENT Comment MySQL extension
select column_name from information_schema.columns where table_name = '你的表2';
insert into 你的表1
select column_name from information_schema.columns where table_name = '你的表xxx'
select column_name from information_schema.columns where table_name = '你的表2';