Advertisement
Guest User

Untitled

a guest
Jul 19th, 2017
494
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. mysql> SELECT * FROM answers ORDER BY question_id;
  2. +----+----------------------------+----------------+-----------+-------------+-------------------+
  3. | id | session_id | ip | survey_id | question_id | answer |
  4. +----+----------------------------+----------------+-----------+-------------+-------------------+
  5. | 1 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 1 | npoole@gmail.com |
  6. | 2 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 2 | 14 - 18 |
  7. | 3 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 3 | 5 - 10 |
  8. | 4 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 4 | 1 - 3 hours |
  9. | 5 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 5 | 1 - 2 days |
  10. | 6 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Adventure |
  11. | 7 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Puzzle |
  12. | 8 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 6 | Casual (Facebook) |
  13. | 9 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 7 | Yes |
  14. | 10 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 8 | Webkinznews.com |
  15. | 11 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 9 | No |
  16. | 12 | f9i0mg58lqnimjl37pi5519th7 | 192.168.59.170 | 1 | 11 | Yes |
  17. +----+----------------------------+----------------+-----------+-------------+-------------------+
  18. 12 rows in set (0.00 sec)
  19.  
  20.  
  21. I need the following format ...
  22.  
  23. npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Adventure | Yes | Webkinznews.com | No | Yes
  24. npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Puzzle | Yes | Webkinznews.com | No | Yes
  25. npoole@gmail.com | 14 - 18 | 5 - 10 | 1 - 3 hours | 1 - 2 days | Casual (Facebook) | Yes | Webkinznews.com | No | Yes
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement