Error in DB with lines - how to fix?

0 like 0 dislike
37 views
The same error occurs when adding entries to the guest book ("Error adding record!") and when you try to register. The code is almost the same.
Create database

CREATE TABLE `mysite-local`.`guestbook` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `comment` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM CHARSET=utf8 COLLATE utf8_general_ci;

In phpMyAdmin "MySQL returned an empty result (i.e. zero rows). (Query took 0.0005 sec)"

Open Server
in the MySQL Manager, the "key index 'zip code 1" does not contain any column"

5aecccf6d523c901698319.jpeg
by | 37 views

1 Answer

0 like 0 dislike
Insert into table(code which you have given) such a mistake to give can not. Because there is no index, Index "1".
View indexes established in the table in which you do the insert.
by
110,608 questions
257,186 answers
0 comments
33,962 users