参考这篇博客https://blog.csdn.net/zengraoli/article/details/16857835
数据库外键定义:
数据库外键作用:
数据库外键和主键的区别:
数据库外键demo;
创建数据库
DROP schema IF EXISTS `demo`;
CREATE schema demo;
创建表
drop table if exists `demo`.`user`;
CREATE TABLE user_info
(
`user_id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`username` NVARCHAR(64) COLLATE utf8_general_ci DEFAULT NULL,
`password` NVARCHAR(64) COLLATE utf8_general_ci DEFAULT NULL,
`qianming` TEXT COLLATE utf8_general_ci,
`email` NVARCHAR(64) COLLATE utf8_general_ci DEFAULT NULL,
`pic` VARCHAR(64) COLLATE utf8_general_ci DEFAULT