setting value for all records

[Dave]

Hi

How would i go about populating a new column based on an existing column
pluse a bit of text

i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want to
poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.

Could anyone help me with the sql pleae.

Many thanks

Dave

[strawberry]

Dave wrote:

Hi

How would i go about populating a new column based on an existing column
pluse a bit of text

i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want to
poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.

Could anyone help me with the sql pleae.

Many thanks

Dave

Have a look at concat()

[Dave]

That's great, thanks, I've managed to update all of my records, but I can't
seem to set this CONCAT() as the default value. How would I do that?
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>
Dave wrote:

>Hi

How would i go about populating a new column based on an existing column
pluse a bit of text

i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want
to
poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.

Could anyone help me with the sql pleae.

Many thanks

Dave

Have a look at concat()

[Michael Austin]

Dave wrote:

That's great, thanks, I've managed to update all of my records, but I can't
seem to set this CONCAT() as the default value. How would I do that?
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

>>Dave wrote:

>>>Hi

How would i go about populating a new column based on an existing column
pluse a bit of text

i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want
to
poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.

Could anyone help me with the sql pleae.

Many thanks

Dave

Have a look at concat()

use a trigger( functionality added after 5.0 or later ) or have it done by the
application storing the data.

see: http://dev.mysql.com/doc/refman/5.0/...e-trigger.html

CREATE TRIGGER sometriggername BEFORE INSERT ON `sometable`
FOR EACH ROW
BEGIN
SET NEW.fldIMAGE = concat(NEW.fldid,'.jpg');
END
;
--
Michael Austin.
Database Consultant