Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Joining two columns (fields) ?

westmatrix's profile image westmatrix posted 13 years ago in General Permalink
How do I join two columns (fields) in one db table ? - (wish there was a drag & drop function)

Two columns (fields)
usr_name => name
usr_surname => surname
Would like to join them;
name surname in one table called usr_name

Is there a join or merge query that can do this like;
merge usr_name," ",usr_surname into usr_name


Cheers
westmatrix's profile image westmatrix posted 13 years ago Permalink
This worked
update tbl_login set usr_name = concat(usr_name,' ',usr_surname)

For future - if anyne needs db help go here first;

http://dev.mysql.com/doc/refman/5.0/en/index.html

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat


Cheers

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.