mysql - 如何导出/导入某些行？

Question

我的数据库中有这样一张表(用于游戏):

 id   name   playcount
---- ------ -----------
 1    game#1  17
 2    game#2  22

等，字段播放计数具有属性 DEFAULT 0;因此，假设我想通过导出除游戏计数之外的所有字段来重新创建此数据库。

我该怎么做？一个 phpmyadmin 解决方案就可以了。谢谢!

Answer 1

你可以在上面使用INTO OUTFILE，生成CSV格式

SELECT  id, name, 0 AS playcount
        INTO OUTFILE 'backup.txt'                       -- this is the location
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
        LINES TERMINATED BY '\n'
FROM TableName;

加载文件，使用LOAD DATA INFILE Syntax

LOAD DATA INFILE 'backup.txt'
INTO TABLE TableName
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';