Replace username with Firstname + '.'+lastname
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.
Subject
Written By
Posted
Replace username with Firstname + '.'+lastname
May 03, 2011 04:28PM
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.