易截截图软件、单文件、免安装、纯绿色、仅160KB

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 ---- 行终止符


相关文档:

MySQL重复记录 查询及删除

查询及删除重复记录的方法
(一)
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid ......

Linux环境的AMP安装 MYSQL安装


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 ......

MYSQL从文本文件执行SQL


将SQL语句放到一个文件中然后告诉mysql从该文件读取输入,eg:
shell>mysql db_name < text_file
如果正在运行mysql,可以使用"source"或"\."命令执行SQL脚本文件:
mysql>source filename
mysql>\. filename
例如,要在数据库test中创建表和插入数据,其中创建表和插入数据的SQL语 ......

MySQL partition分区I

一、        分区的概念
二、        为什么使用分区?(优点)
三、        分区类型
四、        子分区
五、        对分区进行修改(增加、删除、分解、 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号