2114772318 2020-01-19 19:01 采纳率: 25%
浏览 320

数据库导入sql脚本error1215

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50521
Source Host : localhost:3306
Source Database : mybatis

Target Server Type : MYSQL
Target Server Version : 50521
File Encoding : 65001

Date: 2015-04-09 16:03:53
*/

SET FOREIGN_KEY_CHECKS=0;


-- Table structure for orders


DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) NOT NULL COMMENT '下单用户id',
number varchar(32) NOT NULL COMMENT '订单号',
createtime datetime NOT NULL COMMENT '创建订单时间',
note varchar(100) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (id),
KEY FK_orders_1 (user_id),
CONSTRAINT FK_orders_id FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;


-- Records of orders


INSERT INTO orders VALUES ('3', '1', '1000010', '2015-02-04 13:22:35', null);
INSERT INTO orders VALUES ('4', '1', '1000011', '2015-02-03 13:22:41', null);
INSERT INTO orders VALUES ('5', '10', '1000012', '2015-02-12 16:13:23', null);


-- Table structure for user


DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(32) NOT NULL COMMENT '用户名称',
birthday date DEFAULT NULL COMMENT '生日',
sex char(1) DEFAULT NULL COMMENT '性别',
address varchar(256) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;


-- Records of user


INSERT INTO user VALUES ('1', '王五', null, '2', null);
INSERT INTO user VALUES ('10', '张三', '2014-07-10', '1', '北京市');
INSERT INTO user VALUES ('16', '张小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('22', '陈小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('24', '张三丰', null, '1', '河南郑州');
INSERT INTO user VALUES ('25', '陈小明', null, '1', '河南郑州');
INSERT INTO user VALUES ('26', '王五', null, null, null);

  • 写回答

1条回答 默认 最新

  • threenewbee 2020-01-20 09:14
    关注
    评论

报告相同问题?

悬赏问题

  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 怎么在stm32门禁成品上增加记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B
  • ¥15 想问一下stata17中这段代码哪里有问题呀
  • ¥15 flink cdc无法实时同步mysql数据
  • ¥100 有人会搭建GPT-J-6B框架吗?有偿
  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号