增:
Insert Into T_Person(FName,FAge) values('Jim',25)
Insert into T_Person(FName) values('lily')Insert into T_Person values('poly',33) //不推荐
删:
Delete From T_Person //是删除T_Person表中的数据, 表还在,数据没了,人去楼空delete from T_Person where FName='Jim'
delete from T_Person where FAge>30
改:
Update T_Person Set FAge=30update T_Person Set FAge=50 where FName='Tom'
update T_Person Set FAge=50 where FName='Tom' OR FName='Jim'
查:
Select * from T_Person //显示T_Person的所有数据Select * from 表名
其他:
rename table table1 to table2;