Re: Primary key ID gets messed up after deleting/adding

2001-04-08 Thread Kobus Myburgh
No, what is meant here is that: He has record 1 2 3 and 4. Now deletes 2 and 3. Now create 2 new records. MySQL creates them as 5 and 6, instead of 2 and 3 again... --Kobus >>> Lindsay Adams <[EMAIL PROTECTED]> 2001-04-08 19:42:12 >>> I can understand not wanting to have holes, but.. If it is

Re: Primary key ID gets messed up after deleting/adding

2001-04-08 Thread Kobus Myburgh
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to actually do this for you? -- Kobus >>> "Jens Vonderheide" <[EMAIL PROTECTED]> 2001-04-08 19:25:48 >>> > When I first added about 10 records and then deleted a few records and > then added more records it did

Setting up MySQL on Windows 2000

2001-04-08 Thread Kobus Myburgh
Folks, I am totally new to databases, haven't got the foggiest of what's going on here. I have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how to even configure it, even though I have read several articles about using it, and consulted our webmaster, but he's go