Click here to Skip to main content
15,921,276 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI friends,
In my project am using MySQL to create stored procedures. In that am having a situation for an employee details registration, a machine code(a sequence number) wants to be generated that machine code format is given below:

When an employee is registered, a machine code has to be generated based on the industyr.

Machine Code(a sequence number) contains 4 characters:

First character determines the industry(details given below).

1- ABC industry
2- ABC poultry farms.
3- ABC mechanics

The remaining 3 digits are the Sequence numbers which starts from 001.
Sabari Karthik 9-Dec-13 4:22am    
In this i need a logic to solve please suggest the logic to solve.

1 solution

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900