MYSQL数据库(三)记录的操作 增删改
表结构:员工数据表
1、删除记录:delete from employees where emp_no=10011; 删掉员工编号为10011的员工记录 这里删除delete 之后 没有*
mysql> delete from employees where emp_no=10011;
Query OK, 1 row affected (0.09 sec)
2、删除列:alter table employees drop column `gender`; 删除表employees 的gender列 删除列是修改表
mysql> alter table employees drop column `gender`;
Query OK, 0 rows affected (0.73 sec)
Records: 0 Duplicates: 0 Warnings: 0
删除之后
3、增加列:alter table employees add column `gender` enum('M','F') not null; 给表employees 增加名为gender的枚举列,列有M,F两个选项
alter table employees add column `gender` enum('M','F') not null;
Query OK, 0 rows affected (0.24 sec)
Records: 0 Duplicates: 0 Warnings: 0
增加之后,枚举列最后默认的都是M
4、改gender属性: update employees set gender='F' where emp_no=10001; 将员工号为10001的员工的性别修更新为F
5、增加记录:insert into employees values (10011,'1956-07-09','Tom','Hanks','2020-04-01','M');在表employees中插入记录
insert ignore into employees 插入数据,如果数据已经存在,则忽略,否则插入。是否存在是按照主键是否相同
mysql> insert into employees values (10011,'1956-07-09','Tom','Hanks','2020-04-01','M');
Query OK, 1 row affected (0.07 sec)
插入之后