MySQL INTO OUTFILE导出导入数据|mysqldump
来源:互联网 发布:swift 自定义元素数组 编辑:程序博客网 时间:2024/05/14 19:36
--使用SELECT ... INTO OUTFILE 以逗号分隔字段的方式将数据导入到一个文件中:
点击(此处)折叠或打开
- SELECT * INTO OUTFILE 'C:\\log1.txt' FIELDS TERMINATED BY ',' FROM log.log1
--将刚刚导出的文件log1.txt导入到表log1相同结构的LOG2中
点击(此处)折叠或打开
- LOAD DATA INFILE 'C:\\log1.txt' INTO TABLE aa.log2 FIELDS TERMINATED BY ',';
-- 使用select * into outfile 导出
点击(此处)折叠或打开
- SELECT * INTO OUTFILE '/tmp/fi.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test.fi;
"2013-04-09 00:06:59","1068029027","EXPORT_INFO","BUY_ITEM_INNER",16,7,304,7,"11","2",70
"2013-04-09 00:08:27","100000198108800","EXPORT_INFO","BUY_ITEM_INNER",65,2,1004,2,"11","2",20
-- 导入
点击(此处)折叠或打开
- LOAD DATA INFILE '/tmp/fi.txt' INTO TABLE test.fii FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
总结:
FIELDS TERMINATED BY ',' 字段间分割符
OPTIONALLY ENCLOSED BY '"' 将字段包围 对数值型无效
LINES TERMINATED BY '\n' 换行符
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysqldump也有同样功能
点击(此处)折叠或打开
- # mysqldump -uroot -p -T/tmp test fi --fields-enclosed-by=\" --fields-terminated-by="\t
0 0
- MySQL INTO OUTFILE导出导入数据|mysqldump
- MySQL INTO OUTFILE导出导入数据|mysqldump
- MySQL INTO OUTFILE导出导入数据|mysqldump
- MySQL INTO OUTFILE导出导入数据
- mysql outfile infile 导入导出数据(附加mysqldump)
- MySQL 导出数据select into outfile用法
- 使用mysqldump、into outfile和load data进行数据库导入导出备份
- 使用mysqldump、into outfile和load data进行数据库导入导出备份
- MySQL数据导出导入(mysqldump)
- 使用python将mysql数据导入excel-select into outfile
- mysql infile/outfile 导入导出
- mysql迁移-----拷贝mysql目录/load data/mysqldump/into outfile
- MySQL使用SELECT...INTO OUTFILE导出文本文件
- MySQL使用SELECT INTO OUTFILE导出文本文件
- MySQL数据导入与导出(select|mysqldump)
- MySQL数据的导出和导入-mysqldump
- mysql mysqldump导入导出
- mysqldump 导出、导入数据
- CKEditor高级编辑器
- 关于以16进制打印字符型出现FFFF**的问题
- 大话——Android Studio 初步配置,终于全部搞好了!!!
- C++ 实现string的split
- SpringMVC图片上传
- MySQL INTO OUTFILE导出导入数据|mysqldump
- IOS开发-14.利用代码添加autolayout约束
- x264中bs.h文件部分函数解读
- cocos2dx自学之路 精灵执行动作+TableView控件
- 4.第三单元任务三实训:编写一个类ExceptionTest,在main方法中使用try-catch-finally语句结构实现:在try语句块中,编写两个数相除操作,相除的两个操作数要求程序运行时用
- iOS中几种数据持久化方案
- java动态代理
- ohasd failed to start错误解决办法
- POJ 2387