存储过程生成主键
- 作者: 飞扬的小胖子
- 来源: 51数据库
- 2022-08-17
delimiter $$ CREATE PROCEDURE generateKeys(in pm_name varchar(20)) begin declare curr_Key varchar(20); declare next_Key varchar(20); declare prefix_Value varchar(5); declare suffix_value int; select x.nextValue,x.DefaultPrefix,x.suffixValue into curr_Key,prefix_Value,suffix_Value from pm_tableprimaryinfo x where x.table_name=pm_name; if (curr_Key is null or curr_Key='') THEN set suffix_Value='0'; else set suffix_Value = suffix_Value+1; END if; set curr_Key = concat(prefix_Value, suffix_Value); update pm_tableprimaryinfo x set x.nextValue=curr_Key, x.suffixValue=suffix_Value where x.table_name=pm_name; SELECT curr_Key; END
推荐阅读
