数据库管理命令

create database kgc #创建数据库;

create table ky08 #创建一张表；
(id int not null,name char(10) not null,
sroce decimal(5,2),passwd char(48) default ‘’,
PRIMARY key(id));

insert into ky08(id,name,sroce,passwd,sex) values (1,‘黄志欢’,80.5,‘huangzhihuan’,‘男’);
insert into ky08(id,name,sroce,passwd,sex) values (2,‘丁宁’,90.5,‘dingning’,‘男’);
insert into ky08(id,name,sroce,passwd,sex) values (3,‘陈巍’,75.5,‘chenwei’,‘男’);
insert into ky08(id,name,sroce,passwd,sex) values (4,‘云洋’,65.5,‘yunyang’,‘男’);
insert into ky08(id,name,sroce,passwd,sex) values (5,‘王宇伟’,85.5,‘wangyuwei’,‘男’);
insert into ky08(id,name,sroce,passwd,sex) values (6,‘韩非凡’,75,‘hanfeifan’,‘男’);

alter table ky08 add sex char(3) #增加一列

select * from ky08 limit 2,3

update ky08 set sroce=75.5 where name=‘黄志欢’

alter table ky08 rename KY08 #修改表名

truncate table ky08

alter table ky08 drop sex #删除列

create table if not exists info ( #表明存在就不在创建该表

id int(4) zerofill primary key auto_increment,
name varchar(10) not NULL,
cardid int(20) not null unique KEY,
hobby varchar(50)
);

insert into info values (1,‘dingning’,123,‘run’)
insert into info values (2,‘黄志欢’,124,‘run’)

create table test like info #复制info的表结构

insert into test select * from info #将info表的内容复制到test表中；

create table test1 (select * from ky08) #方法二，创建表和复制KY08表的内容；