The correct question is if it's even possible to use a non integer field
with auto_increment with MySQL (assuming it's MySQL)
and the answer is : No. you must use an int type.
>From the MySQL manual : "An integer column may have the additional attribute
AUTO_INCREMENT. ".
Sincerely
berber
Visit http://www.weberdev.com Today!!!
To see where PHP might take you tomorrow.
-----Original Message-----
From: Ben Cairns [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Auto_Increment
What is the best field type to use for an Auto_Increment field?
i am using int at the moment, is there a better one?
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK......"
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]