mysql存储过程 [英] mysql stored procedures

问题描述

嗨朋友，
在我的项目中，我正在使用MySQL创建存储过程.由于存在员工详细信息注册的情况，因此需要生成机器代码(序列号)，该机器代码格式如下:

注册员工时，必须根据行业生成机器代码.

机器代码(序列号)包含4个字符:

第一个字符决定行业(详细信息如下).

1- ABC行业
2- ABC家禽养殖场.
3- ABC机械师

剩下的3位数字是从001开始的序列号.

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.

推荐答案

http://en.wikipedia.org/wiki/Stored_procedure [ ^ ]

这篇关于mysql存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！