Skip navigation links

MySQL Forums :: MySQL Query Browser :: Replace username with Firstname + '.'+lastname


Advanced Search

Replace username with Firstname + '.'+lastname
Posted by: Harish Shelat ()
Date: May 03, 2011 04:28PM

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.

Options: ReplyQuote


Subject Written By Posted
Replace username with Firstname + '.'+lastname Harish Shelat 05/03/2011 04:28PM
Re: Replace username with Firstname + '.'+lastname Pratik Asthana 08/18/2011 08:07AM
Re: Replace username with Firstname + '.'+lastname Pratik Asthana 08/18/2011 08:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.