How do I create a MySQL table with an auto increment field?

[PapaGeek]

I downloaded and installed XAMPP 7.1.11 and I am trying to create a table with an auto increment key.

Database test1, table Users, fields xxx and Name.

Using XAMPP Control Panel v3.2.2: I start Apache and MySQL, then I click on Admin on the MySQL line and get the phpMyAdmin page.

Click on Databases, enter test1 in the Create database field, leave the dropdown as “Collation” and click on Create.

The database is created and I enter “Users” in the Create table name field and change the number of columns to 2, then I click “Go”.

I enter “xxx” in the first name field, leave type as INT, set Length to 10, leave default as None and click the A…I box.

When I do that a form pops up labeled Add index, and I cancel out of it. I have tried all different ways of handling that pop up menu, nothing works!

I fill in the second field as Name, Varchar 50.

The preview SQL gives me:

Code: Select all

CREATE TABLE `test1`.`Users` ( `xxx` INT(10) NOT NULL AUTO_INCREMENT , `Name` VARCHAR(50) NOT NULL ) ENGINE = InnoDB;

Then I hit the save button and get the pop up message:

Code: Select all

#1075: Incorrent table definition, there can be only one auto column and it must be defined as a key.

The dropdown for Type for each column does not include “key”. How do I create a table with an auto increment key?

[Nobbie]

When I do that a form pops up labeled Add index

Exactly, as AUTO_INCREMENT is an attribute of the PRIMARY Key and nothing else.

and I cancel out of it.

Why?? You *should* apply "PRIMARY" here, as you want AUTO_INCREMENT.

I have tried all different ways of handling that pop up menu, nothing works!

Of course not, if you activate AUTO_INCREMENT, you automatically MUST define this as key.

The dropdown for Type for each column does not include “key”.

Of course not, "key" is NOT a datatype (types are "CHAR" or "INT" etc.), the key is a so called "Index" and therefore the Index Box pops up to force you to apply a proper index / key.

How do I create a table with an auto increment key?

Without any? SImply dont activate A...I for any field. But a table without any key is stupid (sorry, but SQL without keys is like a knife without a blade missing the handle).