创建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