#1075 MySQL Error

Question

So i am just a beginner in all this php stuff. I know just the basics, and when i setting up the settings for my new table, I met the problem #1075. Before, i created one, almost similar to this one, and i don't see the differenc. Can you say me where is the problem and explain what is happening?

CREATE TABLE `try`.`testing` ( `id` INT NOT NULL AUTO_INCREMENT , `date` DATE NOT NULL , `text_1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `text_2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE = MyISAM;

here is the code of my SQL Preview. I use phpMyAdmin, obviously. Please, help me. Thank, you)

score 1 · Accepted Answer · answered Jan 13 '16 at 06:27

1

Try this

CREATE TABLE `testing` (
  `id` INT NOT NULL AUTO_INCREMENT, 
  `date` DATE NOT NULL, 
  `text_1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 
  `text_2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = MYISAM ;

answered Jan 13 '16 at 06:27

PravinS

2,640
3
21
25

Thank, you! Works well, but can you explain what you did? What was the problem. – Godje Jan 13 '16 at 06:31
for AUTO_INCREMENT column we mush have key, so I have set it as primary key – PravinS Jan 13 '16 at 06:35

score 1 · Answer 2 · edited May 23 '17 at 12:08

You have to declare your AUTO_INCREMENT field as a primary key or a key. So you have to add PRIMARY KEY (id) or KEY (id) to your CREATE TABLE statement:

CREATE TABLE `try`.`testing` ( 
`id` INT NOT NULL AUTO_INCREMENT, 
`date` DATE NOT NULL , 
`text_1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
`text_2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`id`) -- as primary key
KEY (`id`) -- or as key
) ENGINE = MyISAM;

Please also check:

https://stackoverflow.com/a/8114994/3647441

https://stackoverflow.com/a/14087703/3647441

score 0 · Answer 3 · answered Jan 13 '16 at 06:27

0

For an autoincrement field you should have some sort of index associated with it. eg: primary key which is missing

answered Jan 13 '16 at 06:27

Nouphal.M

6,304
1
17
28

Vipin Jain · Answer 4 · 2016-01-13T06:34:02.957

0

Try This.

CREATE TABLE `try`.`testing` ( 
`id` INT NOT NULL AUTO_INCREMENT, 
`date` DATE NOT NULL , 
`text_1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
`text_2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
KEY (`id`) 
) ENGINE = MyISAM;

https://dev.mysql.com/doc/refman/5.6/en/example-auto-increment.html

edited Jan 13 '16 at 06:34

answered Jan 13 '16 at 06:32

Vipin Jain

3,686
16
35

The already fixed this problem, but thank you) What means this **-- or as key** – Godje Jan 13 '16 at 06:33
means you can use primary key or any key in the id. the auto_increment increment by key – Vipin Jain Jan 13 '16 at 06:35

#1075 MySQL Error

4 Answers4