1.查询
select * from lipy_info;
2.插入
(1)全列插入
insert into lipy_info values(‘lipy3’,’li’,17,’W’,1909090);
(2)缺省插入
insert into lipy_info(first_name,last_name,sex) values(‘lipy4’,’py’,’M’);
(3)同时插入多条数据(MySQL特有的)
insert into lipy_info(first_name,last_name,sex) values(‘lipy4’,’py’,’M’),(‘lipy5’,’py1’,’W’);
3.修改
update lipy_info set first_name=’lily_lily’ where age=26;
4.删除
delete from lipy_info where age=3;