增加字段
ALTER TABLE hero_table7 ADD birth DATE NULL
删除字段
ALTER TABLE hero_table7 DROP COLUMN memo
修改字段
ALTER TABLE hero_table8 CHANGE COLUMN NAME heroname VARCHAR(20)
增加数据
INSERT INTO shangpin (shangpinid,shuliang) VALUES(1,100);
INSERT INTO shangpin (shangpinid,shuliang) VALUES(2,100);
INSERT INTO shangpin (shangpinid,shuliang) VALUES(3,100);
INSERT INTO dingdan(dingdanid,zhuangtai) VALUES(1,'no')
INSERT INTO mingxi(mingxiid,shangpinid,lingyong,dingdanid) VALUES(1,1,5,1);
INSERT INTO mingxi(mingxiid,shangpinid,lingyong,dingdanid) VALUES(2,2,14,1);
注释:插入在表中字段中的值
删除数据
DELETE FROM 学生基本信息表 WHERE 学号>1;
注释:删除来自表中的数据 where 条件
修改数据
UPDATE dingdan SET zhuangtai='no' WHERE MOD(dingdanid,2)=0;
UPDATE dingdan SET zhuangtai='yes'WHERE MOD(dingdanid,2)=1;
注释:修改表 选择字段=值 where后面是条件
查询数据
SELECT*FROM 学生基本信息表 WHERE 姓名='王五'
备份数据库
mysqldump -uroot -p123456 --database wt> e:\wt.sql
恢复数据库
mysql -uroot -p123456 --database wt< e:wt.sql