Re: Auto_Increment
| From: | Johannes Janson | Date: | Thu, 29 Mar 2001 17:54:10 +0000 |
| Subject: | Re: Auto_Increment | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8004@lists.php.net to get a copy of this message | ||
Hi,
well usually yuto_increment is used on ID fields.
then depending on how many rows your table has
tinyint (up to 255; 1k), smallint (up to 65535; 2k)
mediumint (up to 16777215; 3k) int (up to 4294967295, 4k).
Johannes
"Ben Cairns" <BenC@intasept.com> schrieb im Newsbeitrag
news:3AC2FA65@tech-01...
> 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: BenC@intasept.com
> 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>