导出 db1 库 t1 表的表结构
select TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_DEFAULT, COLUMN_KEY, COLUMN_COMMENTfrom information_schema.columns where TABLE_SCHEMA = 'db1' and TABLE_NAME = 't1' into outfile "/tmp/t1.csv";
information_schmea.columns 表结构
本文共 288 字，大约阅读时间需要 1 分钟。
导出 db1 库 t1 表的表结构
select TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_DEFAULT, COLUMN_KEY, COLUMN_COMMENTfrom information_schema.columns where TABLE_SCHEMA = 'db1' and TABLE_NAME = 't1' into outfile "/tmp/t1.csv";
information_schmea.columns 表结构
转载于:https://blog.51cto.com/geamover/1789439