-
Notifications
You must be signed in to change notification settings - Fork 0
/
blog.sql
32 lines (25 loc) · 15.9 KB
/
blog.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
BEGIN;
select userID from user where userName="user" into @uid;
insert into tag(userID,tagName) values(@uid,"杂七杂八");
insert into cat(userID,catName) values(@uid,"分类1");
select max(tagID) from tag where userID=@uid and tagName="杂七杂八" into @tid;
select max(catID) from cat where userID=@uid and catName="分类1" into @cid;
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(@uid,@cid,@tid,"测试1",
"测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1",
"medias/featureimages/8.jpg");
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(@uid,@cid,@tid,"测试2",
"你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好",
"medias/featureimages/9.jpg");
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(3,1,27,"测试1",
"测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1",
"medias/featureimages/8.jpg");
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(3,1,27,"测试1",
"你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好",
"medias/featureimages/9.jpg");
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(5,15,47,"测试1",
"测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1测试用例1",
"medias/featureimages/4.jpg");
insert into blog(userID,catID,tagID,title,content,backgroundImg) values(5,15,47,"测试1",
"你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好你好",
"medias/featureimages/5.jpg");
COMMIT;