自己建的，和老師有一丟丟不一樣，數(shù)據(jù)也插入了，自取，可參考。

-- 師徒四人

CREATE TABLE user1(

id TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,

user_name VARCHAR(20),

user_over VARCHAR(20),

mobile VARCHAR(20)

)

INSERT INTO user1 VALUES(NULL,'唐僧','功德佛',NULL);

INSERT INTO user1 VALUES(NULL,'豬八戒','凈壇使者',NULL);

INSERT INTO user1 VALUES(NULL,'孫悟空','斗戰(zhàn)勝佛',NULL);

INSERT INTO user1 VALUES(NULL,'沙僧','金身羅漢',NULL);

SELECT * FROM user1;

-- 悟空結(jié)拜兄弟

CREATE TABLE user2(

id TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,

user_name VARCHAR(20),

user_over VARCHAR(20)

);

INSERT INTO user2 VALUES(NULL,'孫悟空','成佛');

INSERT INTO user2 VALUES(NULL,'牛魔王','被降伏');

INSERT INTO user2 VALUES(NULL,'蛟魔王','被降伏');

INSERT INTO user2 VALUES(NULL,'鵬魔王','被降伏');

INSERT INTO user2 VALUES(NULL,'獅駝王','被降伏');

SELECT * FROM user2;

-- 打怪記錄表

CREATE TABLE user_kills(

id TINYINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,

user_id TINYINT UNSIGNED,

timestr DATETIME,

kills SMALLINT UNSIGNED

)

INSERT INTO user_kills VALUES(NULL,2,'2013-01-10',10);

INSERT INTO user_kills VALUES(NULL,2,'2013-02-01',2);

INSERT INTO user_kills VALUES(NULL,2,'2013-02-05',12);

INSERT INTO user_kills VALUES(NULL,4,'2013-01-10',3);

INSERT INTO user_kills VALUES(NULL,4,'2013-02-11',5);

INSERT INTO user_kills VALUES(NULL,4,'2013-02-06',1);

INSERT INTO user_kills VALUES(NULL,3,'2013-01-11',20);

INSERT INTO user_kills VALUES(NULL,3,'2013-02-12',10);

INSERT INTO user_kills VALUES(NULL,3,'2013-02-07',17);

SELECT * FROM user_kills;

自己建表也不麻煩

最基本的原始表都沒(méi)有 模擬起來(lái)都很麻煩，你也要人性化一點(diǎn)吧