MySQL面试之CRUD(增删改查)
#创建表
create table employee(
id int unsigned primary key auto_increment,
name varchar(32) not null,
salary double not null
);
#查看创建表
show create table employee;
#插入1条记录
insert employee(name, salary) values('tom', 1000);
#同时插入多条记录
insert employee(name, salary) values('jack', 1500), ('jeff', 2000);
#删除记录
delete from employee where name = 'tom';
#更新记录
update employee set salary = 2500 where name = 'jack';
#查找记录
select * from employee where name = 'jack';
#删除表
drop table employee;