Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select id, source, user, description, is_recipe, active, recipe_id from food where user = 53;
- +-------+--------+------+------------------+-----------+--------+-----------+
- | id | source | user | description | is_recipe | active | recipe_id |
- +-------+--------+------+------------------+-----------+--------+-----------+
- | 12864 | user | 53 | A Book | 0 | 1 | NULL |
- | 12842 | user | 53 | Beany Soup | 1 | 1 | NULL |
- | 12863 | user | 53 | Bob's Great Food | 1 | 1 | 71 |
- | 12844 | user | 53 | chicken orange | 1 | 1 | NULL |
- | 12845 | user | 53 | Good Beans | 1 | 1 | NULL |
- | 12838 | user | 53 | Heart Attack | 1 | 1 | NULL |
- | 12870 | user | 53 | Nootest | 1 | 1 | 80 |
- | 12837 | user | 53 | Power Lunch | 1 | 1 | NULL |
- | 12854 | user | 53 | Recipe Test 1 | 1 | 1 | NULL |
- | 12855 | user | 53 | Recipe Test 2 | 1 | 1 | NULL |
- | 12856 | user | 53 | Recipe Test 3 | 1 | 1 | NULL |
- | 12857 | user | 53 | Recipe Test 4 | 1 | 1 | NULL |
- | 12858 | user | 53 | Recipe Test 5 | 1 | 1 | 65 |
- | 12865 | user | 53 | Slurpie | 1 | 1 | 72 |
- | 12843 | user | 53 | Tangy Soup | 1 | 1 | NULL |
- +-------+--------+------+------------------+-----------+--------+-----------+
- 15 rows in set (0.00 sec)
- mysql> DELETE FROM food WHERE user = 53 AND recipe_id = NULL;
- Query OK, 0 rows affected (0.00 sec)
Add Comment
Please, Sign In to add comment