Question 402238 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – 18 errors when trying to insert data into an existing table

This command produces 18 errors that I have not been able to trace after a number of hours of looking:

INSERT INTO `All_Wainwrights` 
            (`id`, `fellName`,`done`, `metres`, `completed_date`) 
    VALUES ('NULL', 'Nethermost Pike', '1','891','2923', '06/02/1967');

Unexpected beginning of statement. (near "INSERT INTO " at position 0)
Unexpected beginning of statement. (near "All_Wainwrights" at position 12)
Unexpected beginning of statement. (near " " at position 29)
Unexpected beginning of statement. (near "id" at position 31)
Unexpected beginning of statement. (near " " at position 36)
Unexpected beginning of statement. (near "fellName" at position 37)
Unexpected beginning of statement. (near "done" at position 48)
Unexpected beginning of statement. (near " " at position 55)
Unexpected beginning of statement. (near "metres" at position 56)
Unexpected beginning of statement. (near " " at position 65)
Unexpected beginning of statement. (near "completed_date" at position 66)
Unexpected beginning of statement. (near " VALUES " at position 83)
Unexpected beginning of statement. (near "’NULL’" at position 92)
Unexpected beginning of statement. (near "’Nethermost Pike’" at position 100)
Unexpected beginning of statement. (near "’1’" at position 119)
Unexpected beginning of statement. (near "’891’" at position 123)
Unexpected beginning of statement. (near "’2923’" at position 129)
Unexpected beginning of statement. (near "’06/02/1967’" at position 137)
SQL query: Copy

INSERT INTO `All_Wainwrights` 
       (`id`, `fellName`,`done`, `metres`, `completed_date`) 
VALUES ('NULL', 'Nethermost Pike', '1','891','2923', '06/02/1967');
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Apologies, I am running the SQL command from within a window via PhpMyAdmin on my web host's server. There is no code before what I have posted:


  2. 0

    Try removing the quotes from your table name and column names

    INSERT INTO All_Wainwrights 
            (id, fellName, done, metres, completed_date) 
    VALUES ('NULL', 'Nethermost Pike', '1','891','2923', '06/02/1967');
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search