Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,093 members, 7,957,092 topics. Date: Tuesday, 24 September 2024 at 07:00 AM |
Nairaland Forum / Science/Technology / Webmasters / Help! Using Update Statement To Replace All NULL Value In A Column In Mysql (451 Views)
HELP ME Error Parsing XML, Line 15, Column 70: The Entity "Raquo" Was Referenced / How To Fill Bank Information Column On Clickbank / How To Fix Annoying Opera Mini Single Column View And Similar Browsers Issues (2) (3) (4)
(1) (Reply)
Help! Using Update Statement To Replace All NULL Value In A Column In Mysql by uvalued(m): 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 Like |
(1) (Reply)
Want Your Site To Show On Google,yahoo And Bing / Adsense Account For Sale / Reasons Why Readers Bounce Off From Your Blog Immediately When They Visit
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 5 |