On Thu, Jul 26, 2001 at 10:17:56AM +0200, Peter Wiherkoski wrote:
> >Hello, what is the best way to handle record id in MySQL? Has MySQL
> >some kind of automatic record id?
>
>
> >if you need a record id which increments automatically, then you can use the
> >int types( tiny, medium or int) with the attribute that it be unsigned and
> >auto_increment like this:
> >record_id mediumint unsigned not null auto_increment
> >
> >regards
> >shane
> >
>
> Yes, but that is not a very god way to do this. Se my posted
> "AUTO_INCREMENT problem in table"
Huh? You had a problem with an auto_increment column because
you mistakenly inserted too large a value. As long as you're
careful not to do that, it works fine.
--
Maurice Aubrey <[EMAIL PROTECTED]>
"Watch the costs and the profits will follow." - Andrew Carnegie
MySQL 3.22.32: up 7.1 days, processed 504,202,203 queries (824/sec. avg.)
---------------------------------------------------------------------
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
