现在我在学习MySQL,问问怎么复制粘贴数据库.-灵析社区

万码F5GTP6P0

SQL命令: SOURCE *.sql; SELECT * FROM 表 INTO OUTFILE '路径文件名'FIELDS TERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY 'rn'; LOAD DATA LOCAL INFILE '路径文件名' INTO TABLE 表FIELDS TERMINATED BY ','LINES TERMINATED BY 'rn'; cmd 命令:mysql -u root -p 库 < *.sqlmysqldump -u root -p 库 > *.sql

阅读量:1

点赞量:0

问AI