₦airaland Forum

am stuck. I have this database table that have
20,000+ rows. A COLUMN PAYMENT has some data and most
of it with the NULL value. So i want to update all NULL in the PAYMENT
COLUMN with value from say CREDIT COLUMN.

I used something like this

UPDATE table
SET

PAYMENT = CREDIT

WHERE PAYMENT IS NULL;

it did not work can someone help?

thanks

Its like you never specify the unique id of the row you intend to update

Use this query instead
Update table SET `payment` = 'credit' WHERE `payment` = 'Null';