MYSQL thowing an syntax error inster into

Question

Here is the code. I´m using MYSQL. It throws a syntax error, and i can´t find the error in this simple command.

 insert into l_mes (id_mes, desc_mes, id_anio)
        values (201601, Ene 2016, 2016), (201602, Feb 2016, 2016)

Problem is here "Ene 2016". If that's a string literal, enclose it in single quotes, `..., 'Ene 2016', ...`. Same for "'Feb 2016". — spencer7593, Jun 19 '18 at 20:46

Aaron Dietz · Accepted Answer · 2018-06-19T21:00:04.733

0

You need ' ticks (single quotes) around 'strings':

insert into l_mes (id_mes, desc_mes, id_anio)
    values (201601, 'Ene 2016', 2016), 
           (201602, 'Feb 2016', 2016)

edited Jun 19 '18 at 21:00

answered Jun 19 '18 at 20:42

Aaron Dietz

score 0 · Answer 2 · answered Jun 19 '18 at 20:42

0

Assuming data types here, you're missing quotes around your string values.

 insert into l_mes (id_mes, desc_mes, id_anio)
        values (201601, 'Ene 2016', 2016), (201602, 'Feb 2016', 2016)

answered Jun 19 '18 at 20:42

squillman

2 Answers2