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!

score 3 · Accepted Answer · answered Jun 10 '12 at 15:19

3

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.

answered Jun 10 '12 at 15:19

GDP

8,109
6
45
82

score 2 · Answer 2 · answered Jul 13 '17 at 07:38

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.

answered Jul 13 '17 at 07:38

Andrea Leganza

447
7
7

Hamid Zandi · Answer 3 · 2019-06-01T21:31:38.973

1

click on key at the end of field, and it makes visible Auto increment option

edited Jun 01 '19 at 21:31

answered Jun 01 '19 at 21:22

Hamid Zandi

2,714
24
32

score 0 · Answer 4 · edited Oct 11 '12 at 14:38

0

I am using Navicat (10.1.0 Mac) Enterprise. In the table creation dialog, there is a checkbox for auto increment which should do the thing that you are looking for.

edited Oct 11 '12 at 14:38

bipen

36,319
9
49
62

answered Jul 26 '12 at 09:51

Volker

1

How to get auto increment work on NAVICAT

4 Answers4