1.插入
insert into wanjia (w_id,w_name,w_brithday) values ('w006','林枫','1234-5-6')
inset 关键字表示插入 into 关键字表示插入到哪一张表
2.修改
update wanjia set w_name=‘西红柿’ where w_name=‘w007’
update 关键字表示修改
set 关键字表示赋值(设置)
update table set 字段=‘值’ where 主键=‘值’
DELETE FROM 表名称 WHERE 列名称 = 值
delete from wanjia where w_name='值'
CONSTRAINT `FK_ID` FOREIGN KEY (`user_id`) REFERENCES `tb_user` (`id`)
删除外键
语法: ALTER TABLE table-name DROP FOREIGN KEY key-id;
例: ALTER TABLE `tb_active` DROP FOREIGN KEY `FK_ID`
添加外键
alter table locstock add foreign key locstock_ibfk2(stockid) references product(stockid)
locstock 为表名, locstock_ibfk2 为外键名 第一个括号里填写外键列名, product为表名,第二个括号里是写外键关联的列名