Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Sep 13th, 2012  |  syntax: None  |  size: 1.43 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> select * from tags;
  2. +----+-------+-------------+---------------------+---------------------+
  3. | id | name  | description | created             | modified            |
  4. +----+-------+-------------+---------------------+---------------------+
  5. | 31 | one   | NULL        | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  6. | 32 | two   | NULL        | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  7. | 33 | three | NULL        | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  8. | 34 | four  | NULL        | 2012-03-27 15:45:48 | 2012-03-27 15:45:48 |
  9. | 35 | five  | NULL        | 2012-03-27 15:45:48 | 2012-03-27 15:45:48 |
  10. +----+-------+-------------+---------------------+---------------------+
  11. 5 rows in set (0.00 sec)
  12.  
  13. mysql> select * from posts_tags;
  14. +----+---------+--------+---------------------+---------------------+
  15. | id | post_id | tag_id | created             | modified            |
  16. +----+---------+--------+---------------------+---------------------+
  17. | 22 |      64 |     31 | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  18. | 23 |      64 |     32 | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  19. | 24 |      64 |     33 | 2012-03-27 15:45:36 | 2012-03-27 15:45:36 |
  20. | 25 |      65 |     33 | 2012-03-27 15:45:48 | 2012-03-27 15:45:48 |
  21. | 26 |      65 |     34 | 2012-03-27 15:45:48 | 2012-03-27 15:45:48 |
  22. | 27 |      65 |     35 | 2012-03-27 15:45:48 | 2012-03-27 15:45:48 |
  23. +----+---------+--------+---------------------+---------------------+
  24. 6 rows in set (0.00 sec)
create a new version of this paste RAW Paste Data