-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathdata-load.sql
23 lines (21 loc) · 3.9 KB
/
data-load.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
INSERT INTO posts(message)
VALUES ('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z'),
('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h'), ('i'), ('j'),('k'), ('l'), ('m'), ('n'), ('o'), ('p'), ('q'), ('r'), ('s'), ('t'), ('u'), ('v'), ('w'), ('x'), ('y'), ('z');
UPDATE posts SET reply_count=100 WHERE post_id=2;
INSERT INTO replies(post_id, message)
VALUES (2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (2, 'm'), (2, 'n'), (2, 'o'), (2, 'p'), (2, 'q'), (2, 'r'), (2, 's'), (2, 't'), (2, 'u'), (2, 'v'), (2, 'w'), (2, 'x'), (2, 'y'), (2, 'z'),
(2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (2, 'm'), (2, 'n'), (2, 'o'), (2, 'p'), (2, 'q'), (2, 'r'), (2, 's'), (2, 't'), (2, 'u'), (2, 'v'), (2, 'w'), (2, 'x'), (2, 'y'), (2, 'z'),
(2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (2, 'm'), (2, 'n'), (2, 'o'), (2, 'p'), (2, 'q'), (2, 'r'), (2, 's'), (2, 't'), (2, 'u'), (2, 'v'), (2, 'w'), (2, 'x'), (2, 'y'), (2, 'z'),
(2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (2, 'm'), (2, 'n'), (2, 'o'), (2, 'p'), (2, 'q'), (2, 'r'), (2, 's'), (2, 't'), (2, 'u'), (2, 'v'), (2, 'w'), (2, 'x'), (2, 'y'), (2, 'z'),
(2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (2, 'm'), (2, 'n'), (2, 'o'), (2, 'p'), (2, 'q'), (2, 'r'), (2, 's'), (2, 't'), (2, 'u'), (2, 'v'), (2, 'w'), (2, 'x'), (2, 'y'), (2, 'z'),
(2, 'a'), (2, 'b'), (2, 'c'), (2, 'd'), (2, 'e'), (2, 'f'), (2, 'g'), (2, 'h'), (2, 'i'), (2, 'j'),(2, 'k'), (2, 'l'), (3,'m'), (3,'n'), (3,'o'), (3,'p'), (3,'q'), (3,'r'), (3,'s'), (3,'t'), (3,'u'), (3,'v'), (3,'w'), (3,'x'), (3,'y'), (3,'z'),
(3,'a'), (3,'b'), (3,'c'), (3,'d'), (3,'e'), (3,'f'), (3,'g'), (3,'h'), (3,'i'), (3,'j'),(3,'k'), (3,'l'), (3,'m'), (3,'n'), (3,'o'), (3,'p'), (3,'q'), (3,'r'), (3,'s'), (3,'t'), (3,'u'), (3,'v'), (3,'w'), (3,'x'), (3,'y'), (3,'z'),
(3,'a'), (3,'b'), (3,'c'), (3,'d'), (3,'e'), (3,'f'), (3,'g'), (3,'h'), (3,'i'), (3,'j'),(3,'k'), (3,'l'), (3,'m'), (3,'n'), (3,'o'), (3,'p'), (3,'q'), (3,'r'), (3,'s'), (3,'t'), (3,'u'), (3,'v'), (3,'w'), (3,'x'), (3,'y'), (3,'z'),
(3,'a'), (3,'b'), (3,'c'), (3,'d'), (3,'e'), (3,'f'), (3,'g'), (3,'h'), (3,'i'), (3,'j'),(3,'k'), (3,'l'), (3,'m'), (3,'n'), (3,'o'), (3,'p'), (3,'q'), (3,'r'), (3,'s'), (3,'t'), (3,'u'), (3,'v'), (3,'w'), (3,'x'), (3,'y'), (3,'z');