SQL SET - urgent

[Vivid Lust]

Hey all

 

Say this was my database:

 

name surname fullName

  foo    bar

  bar    foo

 

How could I create an UPDATE query which would be something like this:

 

UPDATE database SET fullName = name + surname

 

 

thanks all, hope someone could give me an answer as soon as posible, thanks again, much appreciated

[mikesta707]

you answered your own question

UPDATE database SET fullName = name + surname

 

that should do it.

[Mchl]

It's MySQL I presume?

 

UPDATE database SET fullName = CONCAT(name,' ',surname);