MySql 仅导出架构而不导出数据

Question

我在mysql数据库中有一个表列表，不需要导出数据，如何将表导出为CSV结构，而不包含其中的数据，只有结构？

Answer 1

您可以通过以下查询来完成此操作:

操作系统(Windows):

SELECT 
TABLE_NAME,
GROUP_CONCAT(COLUMN_NAME)
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'YOUR_DATABASE_NAME'
GROUP BY TABLE_NAME
INTO OUTFILE 'D:/tableColumnHeaders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

操作系统(Linux):

SELECT 
TABLE_NAME,
GROUP_CONCAT(COLUMN_NAME)
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'YOUR_DATABASE_NAME'
GROUP BY TABLE_NAME
INTO OUTFILE '/tmp/tableColumnHeaders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

注意:将所需的路径放在INTO OUTFILE之后。