()SQL语法初级

2y)O'gXCa\0 

create table testtable(company char(20)not null,number bigint, primary key(company))51Testing软件测试网'D%o6V]6L

insert into testtable values ('pandahall1','1')
0o(v$K:O![h0insert into testtable values ('pandahall2','2')
u)ir#VQJ8n%HE0insert into testtable values ('pandahall3','3')
{VA7X!A^0insert into testtable values ('pandahall4','4')

r\3QL0~g.@4C0delete from testtable where number='4'51Testing软件测试网{j)wQW(r)B

iV?t2@0update testtable set company='pandahall888',number='888' where number='2'51Testing软件测试网_k#K1Sq N}

'[r2ca+Y0U r|0select * from testtable51Testing软件测试网 cWW/cvS(P

alter table testtable add address varchar(30)

;|'Zl\,{0insert into testtable values ('pandahall2','2','shenzhen')51Testing软件测试网{wQlT m#T$}

/J T3KK v ]6qJAV1W0ALTER TABLE testtable DROP COLUMN address51Testing软件测试网)b5~w.K&U

drop table testtable