Re: update combine values

Hi, try this : mysql> select * from usertable; +--+---++--+ | fullname | firstname | Middlename | lastname | +--+---++--+ | NULL | Scott | Junior | Tiger| +--+---++--+ 1 row

RE: update combine values

Ismet Dere wrote: > my question is that, is it possible to combine values of multiple > fields in another field of same table with an update statement such > as this; > > UPDATE UserTable SET FullName = FirstName & MiddleName & LastName; UPDATE UserTable SET FullName

update combine values

Hi am fairly new to mysql and need some help, i have search thru online documents but found not much help to this. my question is that, is it possible to combine values of multiple fields in another field of same table with an update statement such as this; UPDATE UserTable SET FullName = First