mysql常用命令二(创建，查询，修改，删除)

4 dd abcdef dd@gmail.com
5 ee aaaaaa ee@gmail.com
6 ff aaaaaa ff@gmail.com

2、数据传入命令
load data local infile "文件名" into table 表名;
mysql> load data local infile "c:\\data.txt" into table user;
Query OK, 6 rows affected (0.02 sec)
Records: 6 Deleted: 0 Skipped: 0 Warnings: 0

注意：文件的路径要用双斜杠格开。
mysql> select * from user;
+--------+----------+----------+---------------+
| userid | username | password | email |
+--------+----------+----------+---------------+
| 1 | aa | 123456 | abc@sina.com
| 2 | bb | 123456 | def@sohu.com
| 3 | cc | abcdef | cc@gmail.com
| 4 | dd | abcdef | dd@gmail.com
| 5 | ee | aaaaaa | ee@gmail.com
| 6 | ff | aaaaaa | ff@gmail.com
+--------+----------+----------+---------------+
6 rows in set (0.01 sec)
更新字段：
格式:update 表名　set 列名1=值，列名2=值，... where 条件；
mysql> update user set username="modify" where userid ="6";
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from user;
+--------+----------+----------+---------------+
| userid | username | password | email |
+--------+----------+----------+---------------+
| 1 | aa | 123456 | abc@sina.com
| 2 | bb | 123456 | def@sohu.com
| 3 | cc | abcdef | cc@gmail.com
| 4 | dd | abcdef | dd@gmail.com
| 5 | ee | aaaaaa | ee@gmail.com
| 6 | modify | aaaaaa | ff@gmail.com
+--------+----------+----------+---------------+
6 rows in set (0.00 sec)
删除记录：
格式:delete from 表 where 条件；
mysql> delete from user;
Query OK, 6 rows affected (0.04 sec)
mysql> select * from user;
Empty set (0.00 sec)
这一篇我们讲了数据库的创建，表的创建，表的查询，修改，删除等操作，下一篇是关于数据库的备份。

相关资讯