增删改查

创建表

CREATE TABLE cell_list(

CITY varchar(10),

DISTRICT varchar(10),

CELL_ID bigint(20),

CELL_NAME varchar(30),

COVER_VENUES varchar(10),

SITE_TYPE varchar(10),

SITE_BAND varchar(10),

LONGITUDE double(9,6),

LATITUDE double(9,6),

AZIMUTH float(5,2),

RADIUS float(5,3),

BEAMWIDTH int(10),

TAC int(10),

NETWORK_TYPE varchar(10),

band varchar(5))

添加数据

INSERT INTO cell_list (CITY,DISTRICT,CELL_ID,CELL_NAME,COVER_VENUES,SITE_TYPE,SITE_BAND,LONGITUDE,LATITUDE,AZIMUTH,RADIUS,BEAMWIDTH,TAC,NETWORK_TYPE,band)

VALUES(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5);

修改表

alter  table cell_list  change VALUES VALUES float(5,2);

alter  table cell_list drop column VADIUS;

alter  table cell_list add VADIUS float(5,2)

删除表数据

delete from  cell_list

删掉表

drop table cell_list

删除数据库 drop dabatase  dbname;