sql - insert query

Question

I have this table and I want to insert values, but it's not working:

MariaDB [worldmap]> show columns from worldmap_table;
+---------------------+------------------+------+-----+---------+----------------+
| Field               | Type             | Null | Key | Default | Extra          |
+---------------------+------------------+------+-----+---------+----------------+
| ID                  | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| servername          | varchar(100)     | NO   |     | NULL    |                |
| trigger_description | varchar(100)     | NO   |     | NULL    |                |
| long                | int(11)          | NO   |     | NULL    |                |
| lat                 | int(11)          | NO   |     | NULL    |                |
| sev1                | int(11)          | NO   |     | NULL    |                |
| sev2                | int(11)          | NO   |     | NULL    |                |
| sev3                | int(11)          | NO   |     | NULL    |                |
| sev4                | int(11)          | NO   |     | NULL    |                |
| sev5                | int(11)          | NO   |     | NULL    |                |
| severity            | int(11)          | NO   |     | NULL    |                |
+---------------------+------------------+------+-----+---------+----------------+

insert into  worldmap_table (servername ,trigger_description, long, lat, sev1, sev2, sev3, sev4, sev5, severity)
    values ("titi", "tata", 3, 2, 4, 5, 7, 8, 5, 9)

But I get this message:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'long, lat, sev1, sev2, sev3, sev4, sev5, severity) values ("titi", "tata", 3, 2' at line 1

long is a reserved word: dev.mysql.com/doc/refman/5.5/en/…. Enclose it in backticks — forpas
– forpas, Commented Nov 12, 2019 at 13:27

verhie · Accepted Answer · 2019-11-12 13:30:40Z

3

Your query needs backticks, and perhaps also the autoincrement field, with value NULL to trigger a new increment:

insert into  worldmap_table (servername ,trigger_description, long, lat, sev1, sev2, sev3, sev4, sev5, severity)
values ("titi", "tata", 3, 2, 4, 5, 7, 8, 5, 9)

should be

insert into  worldmap_table (`ID`, `servername` ,`trigger_description`, `long`, `lat`, `sev1`, `sev2`, `sev3`, `sev4`, `sev5`, `severity`)
values (NULL, "titi", "tata", 3, 2, 4, 5, 7, 8, 5, 9);

answered Nov 12, 2019 at 13:30

verhie

1,3181 gold badge7 silver badges7 bronze badges

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

2 Comments

jarlh Over a year ago

Back-ticks are only required for reserved keywords. (But can be used for all identifiers.)

verhie Over a year ago

@jarlh correct, and I would also suggest never using reserved keywords as column names, since they are... reserved.

Collectives™ on Stack Overflow

sql - insert query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related