How to get auto increment work on NAVICAT
25,485
Solution 1
I'm not familiar with NAVICAT but if you can run SQL statements directly, try this:
ALTER TABLE `yourTable` CHANGE `id` `id` INT(10) NOT NULL AUTO_INCREMENT
Full docs here.
Solution 2
As reported there is an auto increment checkbox in Navicat, but you have to create an integer key before, save the operation, and reselect the field, now on the bottom area the auto increment checkbox will appear.
Solution 3
click on key at the end of field, and it makes visible Auto increment option
Author by
rahul
Updated on July 19, 2021Comments
-
rahul almost 3 years
I am using NAVICAT to make tables for MYSQL and I am unable to find the auto-increment attribute option for my primary key column.
id integer(10)(auto_increment)primary key
Anyone pls help me out!