₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,325,092 members, 8,420,280 topics. Date: Thursday, 04 June 2026 at 03:33 PM

Toggle theme

Help! Using Update Statement To Replace All NULL Value In A Column In Mysql - Webmasters - Nairaland

Nairaland ForumScience/TechnologyWebmastersHelp! Using Update Statement To Replace All NULL Value In A Column In Mysql (522 Views)

1 Reply

Help! Using Update Statement To Replace All NULL Value In A Column In Mysql by uvalued(op): 2:16am On Aug 27, 2015
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
Re: Help! Using Update Statement To Replace All NULL Value In A Column In Mysql by talk2hb1(m): 6:34am On Aug 27, 2015
Its like you never specify the unique id of the row you intend to update
Re: Help! Using Update Statement To Replace All NULL Value In A Column In Mysql by JackOfAllTrades: 8:07am On Aug 27, 2015
Use this query instead
Update table SET `payment` = 'credit' WHERE `payment` = 'Null';
1 Reply

HELP ME Error Parsing XML, Line 15, Column 70: The Entity "Raquo" Was ReferencedHow To Fill Bank Information Column On ClickbankHow To Fix Annoying Opera Mini Single Column View And Similar Browsers Issues234

[Part 1] Are You Rejected By Adsense? Fix It HereYahoo! Is Officially For Sale As It Lays Off 1,700 WorkersAll You Need To Know About Adsense Africa Publisher Meetup & How To Register