创建表
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;
