Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sql Parameters supplied for object 'Firm' which is not a function

Structure tables and result query on sqlfiddle

I want use query:

INSERT INTO Firm('name', 'name_original', 'id_city', 'id_service', 'id_firm')
VALUES
('РЭД-АВТО ООО', 'РЭД-АВТО ООО', '73041', '2', '1429'),
('УМ-3 ЗАО ', 'УМ-3 ЗАО ', '73041', '2', '49806'),
('ООО West Hole', 'РЭД-АВТО ООО', '73041', '2', '10004');

But i get errors:

Parameters supplied for object 'Firm' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.: 
INSERT INTO Firm('name', 'name_original', 'id_city', 'id_service', 'id_firm') 
VALUES 
('РЭД-АВТО ООО', 'РЭД-АВТО ООО', '73041', '2', '1429'), 
('УМ-3 ЗАО ', 'УМ-3 ЗАО ', '73041', '2', '49806'), 
('ООО West Hole', 'РЭД-АВТО ООО', '73041', '2', '10004')

Tell me please why i get errors and how correct insert data ?


1 Answers

Remove the quotes around your column names.

INSERT INTO Firm(name, name_original, id_city, id_service, id_firm)
VALUES
('РЭД-АВТО ООО', 'РЭД-АВТО ООО', '73041', '2', '1429'),
('УМ-3 ЗАО ', 'УМ-3 ЗАО ', '73041', '2', '49806'),
('ООО West Hole', 'РЭД-АВТО ООО', '73041', '2', '10004');
like image 55
Dave Zych Avatar answered Nov 20 '25 07:11

Dave Zych



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!