Replace username with Firstname + '.'+lastname

[Harish Shelat]

Hello,

I am new to mysql. I have installed mysql and it is working. I have table called customers. This table has field name username (login name). It has also fieldname like firstname, Lastname, etc. This username is like 'abcccd'. I like to replace all usersnames with firstname + '.' Lastname. I tried the command 'Concate_ws but it did not work. How can I replace current username by their firstname.(period)lastname? I do not want to go through one by one record and manually update it.

Thanks,

Haris



Edited 1 time(s). Last edit at 05/03/2011 05:50PM by Harish Shelat.