56,687
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS user_basic;
CREATE TABLE user_basic (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
user_name VARCHAR(20) DEFAULT NULL,
user_sex VARCHAR(2) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
INSERT INTO user_basic(user_name,user_sex)
SELECT '崔健','男' UNION ALL
SELECT '邓超','男' UNION ALL
SELECT '刘涛','女' UNION ALL
SELECT '崔永元','男';
DROP TABLE IF EXISTS user_category;
CREATE TABLE user_category(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
fatid INT UNSIGNED NOT NULL,
user_category VARCHAR(10),
PRIMARY KEY (id),
FOREIGN KEY (fatid) REFERENCES user_basic(id)
) ENGINE=INNODB CHARSET=utf8 COLLATE=utf8_general_ci;
INSERT INTO user_category(fatid,user_category)
SELECT 1,'A' UNION ALL
SELECT 1,'C' UNION ALL
SELECT 1,'D' UNION ALL
SELECT 2,'B' UNION ALL
SELECT 2,'C' UNION ALL
SELECT 3,'C' UNION ALL
SELECT 3,'D' UNION ALL
SELECT 3,'E' UNION ALL
SELECT 4,'D';