1，mysql： left, right, outer, inner, left outer, 以及 right outer.
2,导出数据：
mysql> SELECT * FROM tutorials_tbl -> INTO OUTFILE '/tmp/tutorials.txt';#导出csv格式mysql> SELECT * FROM passwd INTO OUTFILE '/tmp/tutorials.txt' -> FIELDS TERMINATED BY ',' ENCLOSED BY '"' -> LINES TERMINATED BY '/r/n';
3，导入数据：
本文来源gaodai.ma#com搞#代!码网_
mysqldump、load data和mysqlimport
#导出$ mysqldump -u root -p TUTORIALS tutorials_tbl > dump.txt#导入$ mysql -u root -p database_name LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl;mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl -> FIELDS TERMINATED BY ':' -> LINES TERMINATED BY '/r/n';mysql>LOAD DATA LOCAL INFILE 'dump.txt' -> INTO TABLE mytbl (b, c, a);$ mysqlimport -u root -p --local database_name dump.txt
4，将导出的数据直接导入到远程的服务器
$ mysqldump -u root -p database_name / | mysql -h other-host.com database_name
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：随手记mysql_MySQL
转载请注明原文链接：随手记mysql_MySQL
