MySQL基本操作

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;