How to get auto increment work on NAVICAT

Question

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!

Answer 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.

Answer 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.