[thelist] Number of rows per talbe?

[Steve Cook]

Hi Adrian,

Friday night already where you are? It's only Friday morning here so I've
got hours before I can fetch a beer :-(

The 101 rows problem is "Jolly Strange(tm)" - I've not heard of that
happening, so I can't be much help there. Perhaps rather than ranting at
your rpovider you could politely ask them if it's something they know about
:-)

With the auto-increment, the behaviour you mention is standard. I wouldn't
worry about it if I were you. Pretty much all the SQL databases I have seen
do that. I have no idea why (though I guess it's quickest for the program if
it simply maintains an internal pointer and increments it without having to
worry about filling in gaps). Just let auto-increment do it's thing :-)

Strange about the 101 limit though....


.steve


----------------------------------
   WapWarp - http://wapwarp.com
 Wap-Dev - http://www.wap-dev.net
 Cookstour - http://cookstour.org
----------------------------------

> -----Original Message-----
> From: Adrian Fischer [mailto:adrian at logo-logic.com]
> Sent: den 17 november 2000 10:36
> To: The List 
> Subject: [thelist] Number of rows per talbe?
> 
> 
> Hi Guys,
> 
> Another Friday Night and Im stuck in front of the monitor again...
> 
> In my db I cant seem to insert any more than 101 records.  Is 
> it possible
> that my admin has limited my ablity to insert data?  It is 
> mysql.  Or is
> there a limit built in.  I wouldnt think so. So I keep coming 
> back to to the
> host limiting me.
> 
> Before I go ranting at them for doing it I thought I would 
> check with you
> guys.
> 
> Any ideas?
> 
> Oh...and one other thing...with auto increment...if you 
> delete the records
> at the end of the table how come it doesnt start from the now 
> last record
> and start to increment again.  How come it remembers the last 
> number before
> the delete and starts from there.
> 
> 
> Thanks
> 
> Adrian
> 
> 
> 
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 
>