How does Auto Increment work? I follow the procedure but all I get is the following error message see attached
Auto Increment problem
This is because HeidiSQL is formatting the query for MySQL -
This is what HeidiSQL does -
CREATE TABLE "sample_table" ( "row_num" INT NOT NULL AUTO_INCREMENT, PRIMARY KEY ("row_num") )
Just copy the query generated by HeidiSQL from the output window and change as follows:
CREATE TABLE "sample_table" ( "row_num" INT IDENTITY(1,1) PRIMARY KEY )
Please login to leave a reply, or register at first.