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
-----Original Message-----
From: Peter Wiherkoski [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 3:05 PM
To: [EMAIL PROTECTED]
Subject: Record ID
Hello, what is the best way to handle record id in MySQL? Has MySQL
some kind of automatic record id?
/Peter
--------------------------------------
I´m using
MySQL 3.23.39-nt, Windows 2000 Server
--------------------------------------
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
