MySQL笔记

1.报错：Table already exists
解决：在creat table tablename 前加上DROP TABLE IF EXISTS tablename ;
但是由于外键约束会导致无法删除表和表结构，所以应在use schema_name 后加上取消外键约束语句：SET FOREIGN_KEY_CHECKS=0;

参考：
https://blog.csdn.net/lcathm/article/details/47151615
https://blog.csdn.net/u010801439/article/details/78762387

2.新建数据库：create schema
3.执行当前语句快捷键：Ctr+Enter
4.mysql外键
参考：http://www.cnblogs.com/pengyin/p/6375860.html
https://blog.csdn.net/jackliu16/article/details/80727852
在创建表时添加外键：

CREATE TABLE orderitems
(
	order_num int NOT NULL,
	order_item int NOT NULL,
	FOREIGN KEY (order_num) REFERENCES orders(order_num),
	PRIMARY KEY (order_num,order_item)
)ENGINE=InnoDB;

在创建表之后添加外键：

ALTER TABLE orderitems
ADD CONSTRAINT fk_orderitems_orders
FOREIGN KEY (order_num) REFERENCES orders (order_num);

fk_orderitems_orders是外键名