--创建慕课网数据库 imooc
CREATE DATABASE IF NOT EXISTS imooc DEFAULT CHARACTER SET 'UTF8';
--打开imooc
USE imooc;
--用户表user
CREATE TABLE IF NOT EXISTS imooc_user(
id INT,
username VARCHAR(20),
password CHAR(32),
email VARCHAR(50),
age TINYINT,
card CHAR(18),
tel CHAR(11),
salary FLOAT(8,2),
married TINYINT(1),
addr VARCHAR(100),
sex ENUM('男','女','保密'),
)ENGINE=INNODB CHARSET=UTF-8;
2017-09-10 21:09:04
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星