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]

Reply via email to