瓦冷并霜瘦 2017-10-12 13:42 采纳率: 0%
浏览 659

萌新,数据库的建表操作怎么弄

1)根据下面代码,完成mobile_shop数据库的建表操作:
CREATE TABLE ms_member (
member_id int(11) NOT NULL AUTO_INCREMENT,
uname varchar(50) NOT NULL,
password varchar(50) NOT NULL,
email varchar(50) NOT NULL,
sex smallint(6) DEFAULT NULL,
mobile varchar(50) DEFAULT NULL,
regtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
lastlogin timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
image varchar(255) DEFAULT NULL,
PRIMARY KEY (member_id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*………………*/
CREATE TABLE ms_member_address (
address_id int(11) NOT NULL AUTO_INCREMENT,
member_id int(11) NOT NULL,
province varchar(50) DEFAULT NULL,
city varchar(50) DEFAULT NULL,
region varchar(50) DEFAULT NULL,
addr text,
mobile varchar(50) NOT NULL,
receiver varchar(50) NOT NULL,
creatime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
modifytime timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (address_id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

  • 写回答

5条回答 默认 最新

  • 数据甄小白 2017-10-13 01:12
    关注

    什么问题,直接建不就好了,代码没有问题啊

    评论

报告相同问题?