MySQL数据导入导出csv文件命令
MySql数据库导出csv文件命令:
mysql> select first_name,last_name,email from account into outfile 'e:\\output1.csv' fields terminated by ','optionally enclosed by ''lines terminated by '\n';
csv文件效果:
sunny
Grigoryan
lovechoosesun@gmail.com
Jon
Siegal
sun@riliantech.net
Joe
Siegal
zhao@gmail.com
alejandro
medina
wei@gmail.com
cvs文件导入MySql数据库命令:
mysql> load data local infile 'e:\\input1.csv' into table test1 fields termin
ated by ','lines terminated by '\n'(first_name,last_name,email);
Query OK, 1 row affected, 1 warning (0.00 sec)
Records: 69 Deleted: 0 Skipped: 68 Warnings: 0
mysql> select * from test1;
+----+------------+-----------+--------------------------+
| id | first_name | last_name | email |
+----+------------+-----------+--------------------------+
| 0 | sunny | Grigoryan | lovechoosesun@gmail.com
+----+------------+-----------+--------------------------+
FIELDS TERMINATED BY ---- 字段终止字符
OPTIONALLY ENCLOSED BY ---- 封套符
LINES TERMINATED BY ---- 行终止符
相关文档:
查询及删除重复记录的方法
(一)
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid ......
1、MYSQL的安装
1)首先当然是下载源码包咯,如:mysql-5.0.27的安装,http://www.mysql.com
2)解压缩,>tar -zxvf mysql-5.0.27.tar.gz
3)解压完成,进入mysql-5.0.27文件夹,>cd mysql-5.0.27
4)安装配置,>./configure --prefix=/opt/mysql --with-extra-charsets=all --with-unix-socket-path=/opt/m ......
将SQL语句放到一个文件中然后告诉mysql从该文件读取输入,eg:
shell>mysql db_name < text_file
如果正在运行mysql,可以使用"source"或"\."命令执行SQL脚本文件:
mysql>source filename
mysql>\. filename
例如,要在数据库test中创建表和插入数据,其中创建表和插入数据的SQL语 ......
一、 分区的概念
二、 为什么使用分区?(优点)
三、 分区类型
四、 子分区
五、 对分区进行修改(增加、删除、分解、 ......