Catfish Posted December 18, 2009 Share Posted December 18, 2009 How can I find out if a field (or primary key) is set to be auto incrementing? I checked information_schema COLUMNS table but there doesn't seem to be a field for this. I want to be able to identify this to exclude the field from an INSERT query in a PHP script. My script is going to be usable for any table, so I need it to check for this and remove the SQL entries for the field that is auto incrementing. SOLVED: The table I was working with didn't have the primary key as auto_incrementing. This info is held in the EXTRA field of the COLUMNS table in the information_schema database. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.