– 插入操作
create table my_bos(
name varchar(10),
age int
)charset utf8;
insert into my_bos (name) values (‘jack’);
insert into my_bos values (‘jack’,30);
– 查询全部数据
select * from my_bos;
– 查询部分
select name from my_bos;
– 条件查询
select * from my_bos where age = 30;
– 删除数据
delete from my_bos where age = 30;
– 更新数据
update my_bos age = 69 where name = ‘Bob’;
– 更改数据
update my_bos set age = 13 where age = 69;