JoshSpears JoshSpears - 1 year ago 102
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 Source

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:

FROM Wishlist
WHERE id = '18' AND uid = '34i274o1y24ouy1o4'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download