Hi,
Any Thoughts on Gaps created by Auto_Increment Field
Create Table Sales (
billno integer auto_increment (1,1),
customername varchar(45),
product varchar(30),
amount decimal
)
insert into sales (customername,product,amount) values ('xyz', 'ice
cream', 20.00)
-----generates billno = 1
insert into sales (customername,product,amount) values ('abc',
'burger', 30.00)
-----generates billno = 2
delete from sales where billno = 2
insert into sales (customername,product,amount) values ('klm',
'pizza', 50.00)
-----generates billno = 4
Where as the last insert command should have generated 3 as billno.
any help would highly be appriciated.
thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
