各位，現(xiàn)提供該課程建庫建表腳本代碼共享如下。

--?注意自己是否需要建庫
--?create?database?if?not?exists?mysqldv1;

--?新建?user1?表
create?table?if?not?exists?user1?(
??id?smallint?unsigned?primary?key?auto_increment,
??user_name?varchar(40),
??over?varchar(40)
);
--?新建?user2?表
create?table?if?not?exists?user2?(
??id?smallint?unsigned?primary?key?auto_increment,
??user_name?varchar(40),
??over?varchar(40)
);
--?新建?user_kills?表
create?table?if?not?exists?user_kills?(
??id?smallint?unsigned?primary?key?auto_increment,
??user_id?smallint?unsigned,
??timestr?timestamp?default?CURRENT_TIMESTAMP,
??kills?smallint?unsigned
);
--?插入?user1?表數(shù)據(jù)
insert?into?user1(user_name,over)?values?('唐僧',?'旃檀功德佛');
insert?into?user1(user_name,over)?values?('豬八戒',?'凈壇使者');
insert?into?user1(user_name,over)?values?('孫悟空',?'斗戰(zhàn)勝佛');
insert?into?user1(user_name,over)?values?('沙僧',?'金身羅漢');
--?插入?user2?表數(shù)據(jù)
insert?into?user2(user_name,over)?values?('孫悟空',?'成佛');
insert?into?user2(user_name,over)?values?('牛魔王',?'被降服');
insert?into?user2(user_name,over)?values?('蛟魔王',?'被降服');
insert?into?user2(user_name,over)?values?('鵬魔王',?'被降服');
insert?into?user2(user_name,over)?values?('獅駝王',?'被降服');
--?插入?user_kills?表數(shù)據(jù)
insert?into?user_kills(user_id,?timestr,?kills)?values?(2,?timestamp('2013-01-10'),?10);
insert?into?user_kills(user_id,?timestr,?kills)?values?(2,?timestamp('2013-02-01'),?2);
insert?into?user_kills(user_id,?timestr,?kills)?values?(2,?timestamp('2013-02-05'),?12);
insert?into?user_kills(user_id,?timestr,?kills)?values?(4,?timestamp('2013-01-10'),?3);
insert?into?user_kills(user_id,?timestr,?kills)?values?(4,?timestamp('2013-02-11'),?5);
insert?into?user_kills(user_id,?timestr,?kills)?values?(2,?timestamp('2013-02-06'),?1);
insert?into?user_kills(user_id,?timestr,?kills)?values?(3,?timestamp('2013-01-11'),?20);
insert?into?user_kills(user_id,?timestr,?kills)?values?(2,?timestamp('2013-02-12'),?10);
insert?into?user_kills(user_id,?timestr,?kills)?values?(3,?timestamp('2013-02-07'),?17);

#自己手動(dòng)敲的，供參考

?#創(chuàng)建表
CREATE TABLE im_user(
?id INT PRIMARY KEY AUTO_INCREMENT COMMENT '編號(hào)',
?use_name NVARCHAR(10) NOT NULL COMMENT '名稱',
?over NVARCHAR(10) COMMENT '等級(jí)'
);
CREATE TABLE im_friend(
?id INT PRIMARY KEY AUTO_INCREMENT COMMENT '編號(hào)',
?use_name NVARCHAR(10) NOT NULL COMMENT '名稱',
?over NVARCHAR(10) COMMENT '等級(jí)'
); ?#插入表語句
DELETE FROM im_user;
INSERT INTO im_user
VALUES(NULL,'唐僧','玉檀功德佛'),(NULL,'豬八戒','凈壇使者'),
(NULL,'孫悟空','斗戰(zhàn)神佛'),(NULL,'沙僧','金沙羅漢');
?#im_friend
INSERT INTO im_friend
VALUES(NULL,'孫悟空','齊天大圣'),(NULL,'牛魔王','朋友'),
?(NULL,'白骨精','情人'),(NULL,'獅駝王','笨蛋');

自己敲唄