Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Quick MySQL DELETE syntax check >>

Quote Reply
Quick MySQL DELETE syntax check >>
Hey All,

I just wanted to quickly check to see if this MySQL syntax was correct for what I'm trying to do...

At one point while adding links I had several columns set with a default value. (EX. 0.00, http://) Later I found I shouldn't have been adding these default values. What I would like to do is find and delete all of these default values that still remain in my database while leaving the rest.

Is this the correct syntax to delete the default of 0.00 while leaving added values like 49.99???

DELETE FROM lsql_Links
WHERE price = '0.00'

Looks like it should work but I'm not to familiar with MySql commands.

Thanks a lot!
Subject Author Views Date
Thread Quick MySQL DELETE syntax check >> Jonze 3273 Apr 16, 2003, 2:04 PM
Thread Re: [Jonze] Quick MySQL DELETE syntax check >>
afinlr 3179 Apr 16, 2003, 4:40 PM
Thread Re: [afinlr] Quick MySQL DELETE syntax check >>
Jonze 3180 Apr 16, 2003, 5:18 PM
Thread Re: [Jonze] Quick MySQL DELETE syntax check >>
Jonze 3179 Apr 16, 2003, 6:03 PM
Thread Re: [Jonze] Quick MySQL DELETE syntax check >>
Andy 3156 Apr 17, 2003, 4:09 AM
Post Re: [Andy] Quick MySQL DELETE syntax check >>
Paul 3153 Apr 17, 2003, 4:32 AM
Thread Re: [Andy] Quick MySQL DELETE syntax check >>
Jonze 3136 Apr 17, 2003, 11:27 AM
Thread Re: [Jonze] Quick MySQL DELETE syntax check >>
afinlr 3149 Apr 17, 2003, 11:53 AM
Thread Re: [afinlr] Quick MySQL DELETE syntax check >>
Jonze 3112 Apr 17, 2003, 1:22 PM
Thread Re: [Jonze] Quick MySQL DELETE syntax check >>
afinlr 3105 Apr 17, 2003, 1:46 PM
Post Re: [afinlr] Quick MySQL DELETE syntax check >>
Jonze 3111 Apr 17, 2003, 7:13 PM