Why do I get a #1064 with INSERT INTO VALUES?

Question

I created the following table:

CREATE TABLE contactos (
  id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  nombre VARCHAR(60), 
  email VARCHAR(60), 
  password VARCHAR(60), 
  fecha TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY(id)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

But when I try to insert values into the table I get error #1064:

INSERT INTO contactos('ID', 'nombre', 'email', 'password', 'fecha') VALUES (NULL, 'Armando', 'armando_zax@hotmail.com', 'hola', NOW() );

I have researched a lot, but couldn´t get what am I doing wrong.

Also: [When to use single quotes, double quotes, and back ticks in MySQL](https://stackoverflow.com/q/11321491/1941241) — rickdenhaan, Nov 21 '18 at 19:22

Николай Лубышев · Accepted Answer · 2018-11-21T19:28:02.217

0

Becouse you are use a wrong quotes "INSERT INTO contactos(`ID`, `nombre`, `email`, `password`, `fecha`) VALUES ..." When you are mean a field name - then you should use ` quote. When a string constant - use ' quote.

edited Nov 21 '18 at 19:28

answered Nov 21 '18 at 19:22

Николай Лубышев

622
5
10

A `\`` is not a quote character. It is a back tick or https://en.wikipedia.org/wiki/Grave_accent, vs https://en.wikipedia.org/wiki/Quotation_mark – user3783243 Nov 21 '18 at 19:51
May be, but 'Dear myself' call it as an `quote` ))) Sorry, i'm russian ) – Николай Лубышев Nov 21 '18 at 19:53
1

Thank you so much! This code line worked for me: INSERT INTO `contactos`(`ID`, `nombre`, `email`, `password`, `fecha`) VALUES (NULL, 'Armando', 'armando_zax@hotmail.com', 'hola', NOW()) – Armando Andres Flores Nov 21 '18 at 20:02

Why do I get a #1064 with INSERT INTO VALUES?

1 Answers1