mysql建表测试_测试必备mysql技能2：mysql建表

创建istester和idoxu表

CREATE  TABLE  istester (

id  INT(10)  NOT NULL  UNIQUE  PRIMARY KEY  ,

uname  VARCHAR(20)  NOT NULL ,

sex  VARCHAR(4)  ,

birth  YEAR,

department  VARCHAR(20) ,

address  VARCHAR(50) ,

idoxu VARCHAR(20)

);

CREATE  TABLE  idoxu (

id  INT(10)  NOT NULL  UNIQUE  PRIMARY KEY  AUTO_INCREMENT ,

stu_id  INT(10)  NOT NULL ,

c_name  VARCHAR(20) ,

istester VARCHAR(50) ,

grade  INT(10)

);

mysql> create table isTester (id INT(10) NOT NULL UNIQUE PRIMARY  KEY,uname VARCHAR(20) NOT NULL,sex VARCHAR(4),birth YEAR ,department VARCHAR(20),address VARCHAR(50),idoxu VARCHAR(20));

mysql> create table idoxu  (id INT(10) NOT NULL UNIQUE PRIMARY  KEY AUTO_INCREMENT,stu_id INT(10) NOT NULL,c_name VARCHAR(20),istester VARCHAR (50),grade INT(10));

Query OK, 0 rows affected (0.02 sec)