So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100:
> Besides the fakt tha this ID not unique. There ist the Problem that
> the ID you proposed ist an String ID and strings als Index are the
Well, but he could make a two column primary key, where the first is the
timestamp, and the second an unsigned int holding the ip, if the ip is first
transformed from the usual dotted notation (1.2.3.4) to the "raw" number
(which would be 4+3*256+2*256*256+1*256*256*256 in this case -> 16909060 ).
Thus would give a timestamp + integer key, which is fast to index.
> The question still is. Why are auto_increment columns are not supported
True.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die guenstige Art an Linux Distributionen zu kommen
Uptime: 15 hours 19 minutes
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
