MySQL之select into outfile用法
发布时间：2022-03-28 10:51:42 所属栏目：MySql教程 来源：互联网
导读：MySQL之select into outfile用法： 1、select into outfile可以导出数据到指定目录下的文件中 语法： SELECT ... INTO OUTFILE file_name [CHARACTER SET charset_name] [export_options] export_options: [{FIELDS | COLUMNS} [TERMINATED BY string] [[OPT
|
MySQL之select into outfile用法： 1、select into outfile可以导出数据到指定目录下的文件中 语法： SELECT ... INTO OUTFILE 'file_name' [CHARACTER SET charset_name] [export_options] export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] 2、示例如下： 1）查看要导出数据的表t1 mysql> select * from t1; +------+--------+ | id | name | +------+--------+ | 1 | wang | | 2 | steven | | 3 | tiger | | 4 | lilu | +------+--------+ 4 rows in set (0.00 sec) 2）查看导出的文件 [mysql@oneproxy outfile]$ more t1.file 1,"wang" 2,"steven" 3,"tiger" 4,"lilu" 3）创建要导入的表t2; mysql> create table t2 as select * from t1 where 1=2; Query OK, 0 rows affected (0.03 sec) 4）将导出的数据导入t2 mysql> LOAD DATA INFILE '/mysql/outfile/t1.file' INTO TABLE t2 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY 'n'; Query OK, 4 rows affected (0.01 sec) Records: 4 Deleted: 0 Skipped: 0 Warnings: 0 5）查看导入的数据 mysql> select * from t2; +------+--------+ | id | name | +------+--------+ | 1 | wang | | 2 | steven | | 3 | tiger | | 4 | lilu | +------+--------+ 4 rows in set (0.00 sec) （编辑：92站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
