增加一条记录
mysql> insert into emp (id, age, name, gender, salary, depart, is_married)
-> values (1, 22, "lupe", 0, 20000, "技术管理部", 0);
Query OK, 1 row affected (0.00 sec)
mysql> select * from emp;
+----+-----+------+--------+----------+------------+------------+
| id | age | name | gender | salary | depart | is_married |
+----+-----+------+--------+----------+------------+------------+
| 1 | 22 | lupe | 0 | 20000.00 | 技术管理部 | 0 |
+----+-----+------+--------+----------+------------+------------+
1 row in set (0.00 sec)
mysql> INSERT INTO emp(name, salary, depart) values ("瞎驴", 30000, "python");
Query OK, 1 row affected (0.00 sec)
mysql> select * from emp;
+----+-----+------+--------+----------+------------+------------+
| id | age | name | gender | salary | depart | is_married |
+----+-----+------+--------+----------+------------+------------+
| 1 | 22 | lupe | 0 | 20000.00 | 技术管理部 | 0 |
| 2 | 18 | 瞎驴 | NULL | 30000.00 | python | NULL |
+----+-----+------+--------+----------+------------+------------+
2 rows in set (0.00 sec)
加多条记录
INSERT INTO emp(name, salary, depart) values ("瞎驴", 30000, "python"),
("青神", 8000, "ui"),
("Mr.Clean", 50000, "技术研发部");
如果省略了name,需要所有定义的字段都有值
INSERT INTO emp values (20, 22, "小雨", 1, 9000, "人力资源", 1);
set插入
INSERT INTO emp set name = "珊珊";
修改表记录
UPDATE emp set salary = salary + 20000 where name = "lupe";
删除表记录
mysql> DELETE FROM emp where name = "瞎驴" OR id = 20;
Query OK, 7 rows affected (0.00 sec)
mysql> select * from emp;
+----+-----+----------+--------+----------+------------+------------+
| id | age | name | gender | salary | depart | is_married |
+----+-----+----------+--------+----------+------------+------------+
| 1 | 22 | lupe | 0 | 40000.00 | 技术管理部 | 0 |
| 5 | 18 | 青神 | NULL | 8000.00 | ui | NULL |
| 7 | 18 | 青神 | NULL | 8000.00 | ui | NULL |
| 9 | 18 | 青神 | NULL | 8000.00 | ui | NULL |
| 11 | 18 | 青神 | NULL | 8000.00 | ui | NULL |
| 12 | 18 | Mr.Clean | NULL | 50000.00 | 技术研发部 | NULL |
| 21 | 18 | 珊珊 | NULL | NULL | NULL | NULL |
+----+-----+----------+--------+----------+------------+------------+
7 rows in set (0.00 sec)
删除表
mysql> truncate table emp;
Query OK, 0 rows affected (0.02 sec)
DELETE FROM emp;