MySQL implements functions similar to Oracle sequences

drop table if exists sequence;
CREATE TABLE Sequence (
Seq_name VARCHAR () not NULL,
Current_val INT not NULL,
Increment_val INT not NULL DEFAULT 1,
PRIMARY KEY (Seq_name)
);

Drop function if exists currval;
Create function Currval (V_seq_name VARCHAR (50))
Returns integer
Begin
declare value integer;
Set value = 0;
Select Current_val into value
From sequence
where seq_name = V_seq_name;
return value;
End

Create function Nextval (V_seq_name VARCHAR (50))
Returns integer
Begin
DECLARE rowcount integer;

Select COUNT (1) into rowcount
From sequence
where seq_name = V_seq_name;

IF RowCount = 0 Then
INSERT into sequence (seq_name,current_val)
VALUES (v_seq_name,0);
End IF;

Update sequence
Set current_val = Current_val + increment_val
where seq_name = V_seq_name;
Return Currval (V_seq_name);

End

MySQL implements functions similar to Oracle sequences