MySql Query Issue
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Heyhey! So I cannot figure out how to put this data into my MySQL database. All color columns are of DECIMAL Datatype, except for TimeDate which is a DATETIME. I get the following error message:
Error Code: 1054. Unknown column '2015-03-19 15:15:15' in 'field list' 0.000 sec
Here is my query:
INSERT INTO colors.allcolors (Purple,Yellow,Green,Red,TimeDate) VALUES (15,15,15,15,`2015-03-19 15:15:15`)