Friday, 16 March 2018

c# - MySQL Unknown column 'Price' in 'field list'

I'm getting an error when inserting data into a MySql database. I get this error




Error Code: 1054. Unknown column 'Price' in 'field list'




When using this command:




INSERT INTO CubePrice(Price, DateTime, ShopID, CubeID) VALUES ("99.99", "23.41.53 43:12:32", "1", "1")


I have a column named Price in the table CubePrice.
What am I doing wrong? Why do I get this error? I get the same error when trying to use the same query in C#. How can I fix this?



Thanks!

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...