要在mysql中查找列是否为auto_increment，您可以使用以下语法 −
select column_name from information_schema.columns wheretable_schema='yourdatabasename' and table_name='yourtablename' and extralike '%auto_increment%';
let us first create a table. here, clientid is set auto_increment −
mysql> create table autoincrementtabledemo -> ( -> clientid int not null auto_increment primary key, -> clientname varchar(20), -> clientage int, -> clientaddress varchar(100), -> clientcountryname varchar(100) -> );query ok, 0 rows affected (0.61 sec)
现在，让我们找出是否有任何列是auto_increment −
mysql> select column_name from information_schema.columns wheretable_schema='test' and table_name='autoincrementtabledemo' and extra like'%auto_increment%';
以下是输出结果，显示了列，即auto_increment −
+-------------+| column_name |+-------------+| clientid |+-------------+1 row in set (0.00 sec)
以上就是如何在mysql中找到一个列是否为自增列？的详细内容。