phpMyAdmin query

[cheeks2k]

What's wrong with my syntax here?

DELETE * FROM new_gallery WHERE gallery = "webcam"

[nnichols]

Try this -

DELETE * FROM new_gallery WHERE gallery = 'webcam'

nope

DELETE FROM new_gallery WHERE gallery = 'webcam'

You should read the sections of the mysql docs about query syntax.

Hope this helps 😉

[cheeks2k]

I've just tried every combination of single quotes and double quotes, and the syntax you gave me, and still keep getting a syntax error 🙁

[cheeks2k]

... and have just been through the SQL documentation - which doesn't help at all... stumped!

[nnichols]

I was being a bit thick. It should be -

DELETE FROM new_gallery WHERE gallery = 'webcam'

[cheeks2k]

Removed the asterisk, works like a charm! Thanks a lot!

[nnichols]

Good. It's because you can't specify columns in a DELETE statement, and '*' is the specifier for all columns.