Can't find the error in SQL

Question

I cant find the error in this SQL.

INSERT INTO "mod_vehicles_models" (make, name, name_slug, fuel, mass, cylinder_capacity, cylinder_count, energy_label, emission, usage_avg, usage_city, usage_high, capacity_pull_weight, capacity_carry_weight) VALUES ("alfa romeo","alfa romeo 147","alfa-romeo/alfa-romeo-147","benzine","1165","1598","4","","192","8,1","11,1","6,3","1300","")

http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks — Salman A, Nov 02 '14 at 10:05

griffon vulture · Answer 1 · 2014-11-02T11:13:26.433

1

Write the table name without quotes :

INSERT INTO mod_vehicles_models(make, name, name_slug, fuel, mass,
     cylinder_capacity, cylinder_count, energy_label, emission, usage_avg,
     usage_city, usage_high, capacity_pull_weight, capacity_carry_weight)
     VALUES ("alfa romeo","alfa romeo
     147","alfa-romeo/alfa-romeo-147","benzine","1165","1598","4","","192","8,1","11,1","6,3","1300","")

edited Nov 02 '14 at 11:13

answered Nov 02 '14 at 10:04

griffon vulture

6,594
6
36
57

score 0 · Answer 2 · answered Nov 02 '14 at 10:04

0

INSERT INTO "mod_vehicles_models" - remove quotes from table name

answered Nov 02 '14 at 10:04

Maxim Dvorkin

91
1
5

Can't find the error in SQL

2 Answers2