Auto increment column (Serial Type) value will not rollback

[Kapil Dhakad]

Hi,

I am executing following group of statements

insert into table (col2, ..........) values (val2, val3.........)

'col1' of this table is primary key and which is auto-incremented by 1 that is it's a serial key. But when I want rollback insertion then for next insertion it generate next serial key value.

Is rollback of serial key not handle by MySQL internally ?
If No, then what will be alternative solution ?

Thanks in advance
- Kapil Dhakad