Insert Into T_Person(FName,FAge) values(’Jim’,25)
Select * from T_Person
CREATE TABLE `xsglxt`.`t_person` (
`FName` VARCHAR( 256 ) NOT NULL ,
`FAge` VARCHAR( 256 ) NOT NULL
) ENGINE = MYISAM
Update
Insert
Delete
Update
select * from T_Person
Updata T_Person Set FAge=30
update T_Person Set FAge=20 where FName=’Tom’
Delete From T_Person
是删除T_Person里的数据
但是表还在
Insert into test(FNumber,FName,FAge,FSalary) Values(’0002’,’Lily’,19,4300)
select * from test where FSalary>3000
select * from test where FName like ’%m%’
select * from test where FName like ’%m%’ or FName like ’%i%’
select *from test where FSalary<3000 and FSalary>2500
select * from test where FSalary between 2000 and 3000
select SUM(FSalary) from test
select AVG(FSalary) from test
select MAX(FSalary) from test
select MIN(FSalary) from test
select SUM(FSalary),AVG(FSALARY),MAX(FSALARY),MIN(FSalary) from test
select COUNT(*),SUM(FSalary),AVG(FSALARY),MAX(FSALARY),MIN(FSalary) from test
select COUNT(*) from test where FSalary>3000
select COUNT(*),SUM(FSalary),AVG(FSALARY),MAX(FSALARY),MIN(FSalary) from test where FSalary<3000
select * from test order by FSalary asc