Guest User

Untitled

a guest
May 23rd, 2018
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. mysql> select id, source, user, description, is_recipe, active, recipe_id from food where user = 53;
  2. +-------+--------+------+------------------+-----------+--------+-----------+
  3. | id | source | user | description | is_recipe | active | recipe_id |
  4. +-------+--------+------+------------------+-----------+--------+-----------+
  5. | 12864 | user | 53 | A Book | 0 | 1 | NULL |
  6. | 12842 | user | 53 | Beany Soup | 1 | 1 | NULL |
  7. | 12863 | user | 53 | Bob's Great Food | 1 | 1 | 71 |
  8. | 12844 | user | 53 | chicken orange | 1 | 1 | NULL |
  9. | 12845 | user | 53 | Good Beans | 1 | 1 | NULL |
  10. | 12838 | user | 53 | Heart Attack | 1 | 1 | NULL |
  11. | 12870 | user | 53 | Nootest | 1 | 1 | 80 |
  12. | 12837 | user | 53 | Power Lunch | 1 | 1 | NULL |
  13. | 12854 | user | 53 | Recipe Test 1 | 1 | 1 | NULL |
  14. | 12855 | user | 53 | Recipe Test 2 | 1 | 1 | NULL |
  15. | 12856 | user | 53 | Recipe Test 3 | 1 | 1 | NULL |
  16. | 12857 | user | 53 | Recipe Test 4 | 1 | 1 | NULL |
  17. | 12858 | user | 53 | Recipe Test 5 | 1 | 1 | 65 |
  18. | 12865 | user | 53 | Slurpie | 1 | 1 | 72 |
  19. | 12843 | user | 53 | Tangy Soup | 1 | 1 | NULL |
  20. +-------+--------+------+------------------+-----------+--------+-----------+
  21. 15 rows in set (0.00 sec)
  22.  
  23. mysql> DELETE FROM food WHERE user = 53 AND recipe_id = NULL;
  24. Query OK, 0 rows affected (0.00 sec)
Add Comment
Please, Sign In to add comment