Jump to content

Archived

This topic is now archived and is closed to further replies.

dootch

mysql update query

Recommended Posts

I forgot to add an image column to my db I just want it to be vendor_id.jpg I figure its something close to this but I cant get it. [code]UPDATE `products` SET `image` = vendor_id,'.jpg' [/code]

Help please

Share this post


Link to post
Share on other sites
If you have phpmyadmin then just go in and add your column with that file as teh default value.

If you HAVE to do it through php then..

$query = mysql_query("ALTER TABLE `image` ADD `im` VARCHAR( 255 ) DEFAULT 'image.jpg' NOT NULL ");

now varchar limits you to 255 characters - if you need more then use teh text datatype; NOTE you cannot set a default value for text type so you will have to do and extra update after.

PS if that fails it will be down to the privilages you have on teh database

Share this post


Link to post
Share on other sites
Thanks Solved [code]UPDATE products SET image = CONCAT(product_sku, '.jpg ')[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.