Hi,
> Any Thoughts on Gaps created by Auto_Increment Field
> Where as the last insert command should have generated 3 as billno.
I can't reproduce the problem. This is what I did:
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);
insert into sales (customername,product,amount) values ('abc', 'burger', 30.00);
delete from sales where billno = 2;
insert into sales (customername,product,amount) values ('klm', 'pizza', 50.00);
select * from sales;
--> BILLNO CUSTOMERNAME PRODUCT AMOUNT
--> 1 xyz ice cream 20.00
--> 3 klm pizza 50.00
drop table sales;
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
