MySQL Forums
Forum List  »  MySQL Query Browser

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

hi,

my problem is solved using

SELECT CONCAT('E',REPEAT('0', 4-LENGTH(1)),1);

Options: ReplyQuote


Subject
Written By
Posted
August 27, 2011 04:43AM
Re: Generate EmployeeID
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.