ERROR 1064 42000 You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use

Question

While I am trying to insert a row to my table  I m getting the following errors   ERROR 1064  42000   You have an error in your SQL syntax  check the manual that  corresponds to your MySQL server version for the right syntax to use near   filename    VALUES   san    ss   1  1  1  1  2  1  1   sment    notes   sant  at line 1   please help me out   mysql gt  desc risks   ----------------- -------------- ------ ----- --------------------- ----------------    Field             Type           Null   Key   Default               Extra             ----------------- -------------- ------ ----- --------------------- ----------------    id                int 11         NO     PRI   NULL                  auto increment     status            varchar 20     NO           NULL                                     subject           varchar 100    NO           NULL                                     reference id      varchar 20     NO                                                    location          int 11         NO           NULL                                     category          int 11         NO           NULL                                     team              int 11         NO           NULL                                     technology        int 11         NO           NULL                                     owner             int 11         NO           NULL                                     manager           int 11         NO           NULL                                     assessment        longtext       NO           NULL                                     notes             longtext       NO           NULL                                     submission date   timestamp      NO           CURRENT TIMESTAMP                        last update       timestamp      NO           0000-00-00 00 00 00                      review date       timestamp      NO           0000-00-00 00 00 00                      mitigation id     int 11         NO           NULL                                     mgmt review       int 11         NO           NULL                                     project id        int 11         NO           0                                        close id          int 11         NO           NULL                                     submitted by      int 11         NO           1                                        filename          varchar 30     NO           NULL                                    ----------------- -------------- ------ ----- --------------------- ----------------  21 rows in set  0 00 sec     mysql gt  INSERT INTO risks   status    subject    reference id    location    category    team    technology    owner    manager    assessment    notes   filename       VALUES    san    ss   1  1  1  1  2  1  1   sment    notes   santu       ERROR 1064  42000   You have an error in your SQL syntax  check the manual that  corresponds to your MySQL server version for the right syntax to use near   filename    VALUES   san    ss   1  1  1  1  2  1  1   sment    notes   sant  at line 1

User · Answer

This error comes when you have a column name from one of the mysql keyword, try to run your queries by putting all your column names in `` this

example: insert into test (`sno`, `order`, `category`, `samp`, `pamp`, `method`) values(1, 1, 'top', 30, 25, 'Total');

In this example column name order is a keyword in mysql, so i had to put that in `` quotes.

User · Answer

Save code below as command sql USE restaurant TRUNCATE  orders   TRUNCATE  order items    Then run mysql -u root  lt comands sql gt  output tab

User · Answer

I encountered this same error  ERROR 1064  42000   You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near    completed   at line 1  This was the input I had entered on terminal  mysql  create table todos  description  completed    Solution  For each column type you must specify the type of content they will contain  This could either be text  integer  variable  boolean there are many different types of data   mysql  create table todos  description text  completed boolean    Query OK  0 rows affected  0 02 sec   It now passed successfully

User · Answer

ERROR 1064  42000   You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near   lt  Very simple question that you can solved it easily   Please follow my step   change  lt  to   and  gt   to    Just use             enter code here   CREATE TABLE information   - gt  id INT 11  NOT NULL AUTO INCREMENT  - gt  name VARCHAR 30  NOT NULL  - gt  age INT 10  NOT NULL  - gt  salary INT 100  NOT NULL  - gt  address VARCHAR 100  NOT NULL  - gt  PRIMARY KEY id  - gt

User · Answer

Don t quote the column filename  mysql gt  INSERT INTO risks  status  subject  reference id  location  category  team     technology  owner  manager  assessment  notes filename   VALUES   san    ss   1  1  1  1  2  1  1   sment    notes   santu

User · Answer

Execute dump query in terminal then it will work  mysql -u root -p   lt Database Name gt   gt   lt path of the input file gt

User · Answer

There are two different types of quotation marks in MySQL  You need to use   for column names and   for strings  Since you have used   for the filename column the query parser got confused  Either remove the quotation marks around all column names  or change  filename  to  filename   Then it should work

User · Answer

This solution is for windows    Open command prompt in Administrator Mode  Goto path  C  Program Files MySQL MySQL Server 5 6 bin Run below command  mysqldump -h 127 0 01 -u root -proot db table1 table2   result sql

User · Answer

This Error comes due to same table exist in 2 database like you have a database for project1 and in which you have table emp and again you have another database like project2 and in which you have table emp then when you try to insert something inside the database with-out your database name then you will get an error like about   Solution for that when you use mysql query then also mention database name along with table name   OR   Don t Use Reserved key words like KEY as column name

User · Answer

C  xampp gt mysql -u root -p mydatabase  lt  C  DB Backups stage-new sql Enter password  ERROR 1064  42000  at line 1  You have an error in your SQL syntax  check the ma nual that corresponds to your MySQL server version for the right syntax to use n ear  stage-new sql  ----lot of space----    at line 1   The reason was when I dumped the DB I used following command    mysqldump -h  lt host gt  -u  lt username gt  -p  lt database gt   gt  dumpfile sql dumpfile sql   By mistaken dumpfile sql added twice in the syntax   Solution   I removed the dumpfile sql text added to first line of the exported dumpfile

[mysql] ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

Examples related to mysql