mysql数据库建立表总是出错_MySQL数据库建表时怎么出错啊？求大神指点

CREATE TABLE `user` ( `user_id` bigint(18) NOT NULL, `user_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `desig

CREATE TABLE `user` ( `user_id` bigint(18) NOT NULL, `user_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `design_date` datetime DEFAULT NULL, `role_id` bigint(18) DEFAULT NULL, `user_password` varchar(40... CREATE TABLE `user` (

`user_id` bigint(18) NOT NULL,

`user_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

`design_date` datetime DEFAULT NULL,

`role_id` bigint(18) DEFAULT NULL,

`user_password` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

`user_tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,

`office_id` bigint(18) DEFAULT NULL,

`branch_id` bigint(18) DEFAULT NULL,

`station_id` bigint(18) DEFAULT NULL,

PRIMARY KEY (`user_id`),

KEY `r_3` (`role_id`) USING BTREE,

KEY `r_41` (`office_id`) USING BTREE,

KEY `r_42` (`branch_id`) USING BTREE,

KEY `r_43` (`station_id`) USING BTREE,

CONSTRAINT `user_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `user_role` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `user_ibfk_2` FOREIGN KEY (`office_id`) REFERENCES `office` (`office_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `user_ibfk_3` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`branch_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT `user_ibfk_4` FOREIGN KEY (`station_id`) REFERENCES `station` (`station_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8; 展开

展开

全部