Need a SQL sentence to update database

[nob2b]

Hi All,

 

I need a SQL sentence to update database

 

Update target: Table: “ps_product” >> Field:"available_for_order"

 

I just want to change all the value of the field "0" to "1"

 

Is the following sentence correct?

UPDATE `ps_product` SET `available_for_order`=1 

 

 

 

Please help.

[nob2b]

...

[phrasespot]

UPDATE `ps_product` SET `available_for_order`=1 

 

If you prefixed you tables ps_ SQL statement you posted will work. If not, replace the ps_ with whatever you prefixed them with. Though in this case does not make any difference (as only available values for that column are 0 and 1) it is usually a good idea to always use a WHERE clause as well with an UPDATE statement so you do not clobber all rows by accident.