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!
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!