INSERT Failed: Error in MySql syntax in VB.net

Question

I have a transaction procedure like this:

  INSERT INTO transaction(out, taxi_no, driver_name, odometer, date, mileage_out, hours_rent, remittance, total, shortage) VALUES (@out, @taxiNO, @drivername, @odometer, @date, @mout, @hours, @remittance, @total, @shortage)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out, taxi_no, driver_name, odometer, date, mileage_out, hours_rent, remittance, ' at line 1

I just copied the syntax and just change the values from my other project, it works well on my other project but when i tried to run the application, it gives me the error.

That error does not match the query shown. For example, the error shown displays a odometer field that is not present in the query — Pikoh
– Pikoh, Commented Mar 6, 2017 at 12:13
There is almost no way we can help you at present. The error doesn't match the query, as @Pikoh has just said. Where is the out part before the taxi_no? Where is odometer? I feel like this is either the wrong error message that you've given us, or it's not this query throwing it. — David
– David, Commented Mar 6, 2017 at 12:17
So you have an column named out in your table? then try changing that line to this INSERT INTO transaction(`out`, taxi_no, driver_name, odometer, date, mileage_out, hours_rent, remittance, total, shortage) VALUES (@out, @taxiNO, @drivername, @odometer, @date, @mout, @hours, @remittance, @total, @shortage) — Pikoh
– Pikoh, Commented Mar 6, 2017 at 12:24

Pikoh · Accepted Answer · 2017-03-06 12:27:45Z

3

out is a keyword in mysql so please add backtick ie `back quote`

edited Mar 6, 2017 at 12:27

Pikoh

7,72331 silver badges56 bronze badges

answered Mar 6, 2017 at 12:13

Rafiqul Islam

1,6561 gold badge14 silver badges25 bronze badges

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

1 Comment

Rina Over a year ago

oh i see, i didn't knew about it. Thank you so much it worked!

Collectives™ on Stack Overflow

INSERT Failed: Error in MySql syntax in VB.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related