Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Here, my database queries are prepend with >, and the response will be on the line after.
- > SELECT * FROM campaigns WHERE id = 5255555;
- id | campaign | description | author | _user | country | pledged | goal | backers | enddate | _type
- 5255555 | Ergonomic Concrete Gloves | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 227508 | 143131 | 204 | 1546646400 | 12
- > SELECT * FROM campaigns WHERE _user = 'Kirsten67' LIMIT 10;
- id | campaign | description | author | _user | country | pledged | goal | backers | enddate | _type
- ---------+----------------------------+----------------------+---------------+-----------+---------+---------+--------+---------+------------+-------
- 5255501 | Intelligent Steel Soap | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 140584 | 141892 | 21 | 1546905600 | 5
- 5255577 | Fantastic Plastic Chicken | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 27100 | 74909 | 98 | 1546128000 | 14
- 5255578 | Fantastic Wooden Shirt | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 11764 | 98120 | 420 | 1549497600 | 4
- 5255579 | Handmade Fresh Salad | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 22845 | 124475 | 425 | 1544486400 | 2
- 5255580 | Awesome Wooden Pizza | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 59695 | 99833 | 367 | 1544227200 | 8
- 5255581 | Refined Wooden Pizza | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 44807 | 61878 | 12 | 1550361600 | 1
- 5255582 | Incredible Plastic Chips | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 176900 | 145415 | 382 | 1549411200 | 7
- 5255583 | Refined Rubber Chips | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 110404 | 77828 | 155 | 1550880000 | 3
- 5255584 | Sleek Metal Soap | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 48732 | 128615 | 417 | 1550361600 | 8
- 5255585 | Incredible Rubber Keyboard | Campaign description | Kirsten Hayes | Kirsten67 | 3 | 144370 | 59165 | 115 | 1548288000 | 8
Add Comment
Please, Sign In to add comment