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


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.



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.