Re: How to tell if a field type is auto_increment
| From: | Niel Archer | Date: | Mon, 29 Jan 2007 22:52:09 +0000 |
| Subject: | Re: How to tell if a field type is auto_increment | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43008@lists.php.net to get a copy of this message | ||
Hi
Try using:
SHOW COLUMNS FROM db.table LIKE 'field_name%'
and from the returned row, check the 'Extra' column for 'auto_increment'
Niel