深入浅出MySQL(2)

1.插入记录的语法:INSERT INTO tablename(field1,field2,…….,fieldn)VALUES(value1,value2,……valuesn);
向emp中插入入一下记录：ename为zzx1，hiredate为2000-01-01，sal为2000，deptno为1：

mysql> insert into emp(ename,hiredate,sal,deptno) values('zzx1','2000-01-01','2000',1);
Query OK, 1 row affected (0.17 sec)

mysql> select * from emp;
+------+-------+-------+------------+---------+--------+
| age1 | ename | birth | hiredate   | sal     | deptno |
+------+-------+-------+------------+---------+--------+
| NULL | zzx1  | NULL  | 2000-01-01 | 2000.00 |      1 |
+------+-------+-------+------------+---------+--------+
1 row in set (0.07 sec)

insert语句可以一次性插入多条语句,语法:
INSERT INTO tablename(field1,field2,…….,fieldn)
VALUES
(record1_value1,record1_value2,record1_value3,…record1_valuesn),
(record2_value1,record1_value2,record1_value3,…record1_valuesn),
(record3_value1,record1_value2,record1_value3,…record1_valuesn),
……
(recordn_value1,record1_value2,record1_value3,…record1_valuesn);
这个特性使得MySQL在处理大量数据时，节省网络开销，提高插入效率。
2.可以用update命令更新表里的记录值，语法:UPDATE tablename SET field1 = value1,field2 = value2,……fieldn = valuen[WHERE CONDITION]，将zzx1的薪水从2000变为200000,:

mysql> update emp set sal = 200000 where ename = 'zzx1';
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from emp;
+------+-------+-------+------------+-----------+--------+
| age1 | ename | birth | hiredate   | sal       | deptno |
+------+-------+-------+------------+-----------+--------+
| NULL | zzx1  | NULL  | 2000-01-01 | 200000.00 |      1 |
| NULL | dony  | NULL  | NULL       |   1000.00 |   NULL |
+------+-------+-------+------------+-----------+--------+
2 rows in set (0.00 sec)

3.delete命令删除不需要的记录:DELETE FROM tablename[WHERE CONDITION]
在emp中将记录为dony的记录删除:

mysql> delete from emp where ename = 'dony';
Query OK, 1 row affected (0.11 sec)
mysql> select * from emp;
+------+-------+-------+------------+-----------+--------+
| age1 | ename | birth | hiredate   | sal       | deptno |
+------+-------+-------+------------+-----------+--------+
| NULL | zzx1  | NULL  | 2000-01-01 | 200000.00 |      1 |
+------+-------+-------+------------+-----------+--------+
1 row in set (0.00 sec)