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;
萌新,数据库的建表操作怎么弄
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-