MySQL Forums
Forum List  »  MySQL Query Browser

Generate EmployeeID
Posted by: Pratik Asthana
Date: August 27, 2011 04:43AM

Hi,

i have employee table with attributes

employeeid varchar(5)
name varchar(500)

i want to generate employeeid like

E0001
E0002
E0003
-
-
-
E0010

i worked in sql server there is replicate function to perform this type of task.
but i don`t have much idea abt mysql.

please help

Thanks in Advance
Pratik Asthana

Options: ReplyQuote


Subject
Written By
Posted
Generate EmployeeID
August 27, 2011 04:43AM
August 27, 2011 04:52AM


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.