创建函数例子

创建mysql的函数的例子

BEGIN
	declare current_sequence bigint;
  select sequence into current_sequence from s_ct_sequence where dataTableName=p_tablename for update;
	set current_sequence = current_sequence+1;
  update s_ct_sequence set sequence=current_sequence where dataTableName=p_tablename;
	RETURN current_sequence;
END