raja9911 Posted March 14, 2011 Share Posted March 14, 2011 Hi, I am trying to add a model number for all my products. How should i write an SQL command as following (the command might be totally wrong). alter table 'products_model' where 'products_model' == " " ADD 'products_model' = 'products_id' I trying to replace empthy product model number with the product id? Pls help Shan Link to comment Share on other sites More sharing options...
♥kymation Posted March 14, 2011 Share Posted March 14, 2011 UPDATE `products` SET `products_model` = `products_id` WHERE `products_model` = '' Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
burt Posted March 14, 2011 Share Posted March 14, 2011 UPDATE `products` SET `products_model` = `products_id` WHERE `products_model` = ''; Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.