MySQL syntax error #1064 - INSERT

Question

Error:

1064: 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 '(id, name, url, content, category) INTO articles VALUES (null, 'Names', 'names', 'text' at line 1

PHP Code:

$sql = "INSERT (id, name, url, content, category) INTO articles
VALUES (null, '$name', '$url', '$content', '$category')";
$insert = MySQL_Query($sql);

and MySQL database table:

id PRIMARY  tinyint(20)     UNSIGNED   AUTO_INCREMENT 
name        varchar(255)    utf8_general_ci
url         varchar(255)    utf8_general_ci
content     longtext        utf8_general_ci
category    varchar(255)    utf8_general_ci

1064: 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 '(id, name, url, content, category) INTO articles VALUES (null, 'Names', 'names', 'text' at line 1 — Jacob
– Jacob, Commented Jul 11, 2015 at 14:30
If those variables come from user input make sure you are escaping them, or better use prepared statements. — chris85
– chris85, Commented Jul 11, 2015 at 14:36

John Conde · Accepted Answer · 2015-07-11 14:34:11Z

2

You got the first half of the query backwards. First you say what table to insert into, then you list the fields to receive values.

$sql = "INSERT INTO articles (id, name, url, content, category)
VALUES (null, '$name', '$url', '$content', '$category')";

edited Jul 11, 2015 at 14:34

answered Jul 11, 2015 at 14:29

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mureinik · Accepted Answer · 2015-07-11 14:30:19Z

1

Your syntax is incorrect - it should be insert into table_name (column list) values (value list). So, in your case:

$sql = "INSERT INTO articles (id, name, url, content, category)
VALUES (null, '$name', '$url', '$content', '$category')";

answered Jul 11, 2015 at 14:30

Mureinik

316k54 gold badges400 silver badges405 bronze badges

Collectives™ on Stack Overflow

MySQL syntax error #1064 - INSERT

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related