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> 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> 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
This question is related to
mysql
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
Save code below as command.sql
USE restaurant
TRUNCATE `orders`;
TRUNCATE `order_items`;
Then run
mysql -u root <comands.sql> output.tab
C:\xampp>mysql -u root -p mydatabase < 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 <host> -u <username> -p <database> > 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.
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.
Don't quote the column filename
mysql> 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');
Execute dump query in terminal then it will work
mysql -u root -p <Database_Name> > <path of the input file>
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 '<
Very simple question that you can solved it easily ,
Please follow my step : change < to ( and >; to );
Just use: (
);
enter code here
` CREATE TABLE information (
-> id INT(11) NOT NULL AUTO_INCREMENT,
-> name VARCHAR(30) NOT NULL,
-> age INT(10) NOT NULL,
-> salary INT(100) NOT NULL,
-> address VARCHAR(100) NOT NULL,
-> PRIMARY KEY(id)
-> );`
This solution is for windows:
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.
Source: Stackoverflow.com