mysql stored procedures

See more:

MySQL

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.