增删改查

创建表

CREATE TABLE cell_list(

CITYvarchar(10),

DISTRICTvarchar(10),

CELL_IDbigint(20),

CELL_NAMEvarchar(30),

COVER_VENUESvarchar(10),

SITE_TYPEvarchar(10),

SITE_BANDvarchar(10),

LONGITUDEdouble(9,6),

LATITUDEdouble(9,6),

AZIMUTHfloat(5,2),

RADIUSfloat(5,3),

BEAMWIDTH int(10),

TAC int(10),

NETWORK_TYPEvarchar(10),

bandvarchar(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;