JoshSpears JoshSpears - 4 months ago 6
MySQL Question

MySQL syntax error when trying to delete row

I have a simple database query that I can not figure out for some reason.

DELETE * FROM Wishlist WHERE (id, uid) VALUES ("18","34i274o1y24ouy1o4");


This might be just wrong syntax in general. My skills are pretty low when it comes to databases. Any ideas? Just trying to delete a row.

Thanks in advance!

Answer

It looks like you were trying to use the INSERT syntax to do a deletion. If you want to remove records with the criteria you gave try this:

DELETE
FROM Wishlist
WHERE id = '18' AND uid = '34i274o1y24ouy1o4'
Comments