MySQL Workbench auto increment disabled

mysql mysql-workbench
Alexander Ivanov picture Alexander Ivanov · Nov 9, 2015 · Viewed 61.6k times · Source

I am using Workbench version 6.3.5 Community and this is GUI question only.

When creating a new table auto increment check-box is disabled.
Is it a bug or I need to enable this some how in options?
And how to set start value and step for auto increment in GUI when creating a table?

workbench

Answer

Lukas Ignatavičius picture Lukas Ignatavičius · Feb 3, 2016

You need to set auto increment in tableenter image description here

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More