How to get auto increment work on NAVICAT

mysql primary-key increment navicat
rahul picture rahul · Jun 10, 2012 · Viewed 22.9k times · Source

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

GDP picture GDP · Jun 10, 2012

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.

Related questions

How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I …

Read More
difference between primary key and unique key

I'm using mysql database. I have a confusion between primary key and unique key. Please help me where should I create primary and unique key. I mean in which situation we create unique key or primary key .

Read More
Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+…

Read More