How to get auto increment work on NAVICAT

increment, mysql, navicat, primary-key

Solution

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.

Problem

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!

Original source