MySQL error 1054 - Unknown column in Field List

Question

Whenever I try to input data into my tblorder I get the error message  1054 - Unknown column  FK Customer ID  in  field list    I have tried breaking my code down and in doing this I found that the error is repeated for FK Customer ID and OrderQuantity whereas FK DVD ID it will take single data entries  I have tried dropping the table and recreating it  I have dropped the database and recreated it but nothing works  As far as I can tell my code is correct along with my spelling so I m really stuck    My tblorder is-  CREATE TABLE tblorder       Order ID INT AUTO INCREMENT NOT NULL     FK Customer ID INT NOT NULL      FK DVD ID INT NOT NULL       OrderDate DATETIME NOT NULL DEFAULT NOW     OrderQantity INT NOT NULL    PRIMARY KEY  Order ID        FOREIGN KEY  FK Customer ID  REFERENCES tblcustomer  Customer ID     FOREIGN KEY  FK DVD ID  REFERENCES tbldvd  PK ID       The data I am trying to put in is-  INSERT INTO tblorder   FK Customer ID  FK DVD ID  OrderQuantity  VALUES    1  3  2     1  5  1     1  10  4      1  15  3     2  5  4     2  17  3     3  15  1     3  16  1     3  17  1     FK Customer ID is addressing -  CREATE TABLE tblcustomer    Customer ID INT AUTO INCREMENT NOT NULL   FirstName VARCHAR 50  NOT NULL   LastName VARCHAR 50  NOT NULL   Age INT NOT NULL   PRIMARY KEY  Customer ID       FK DVD ID is addressing -   CREATE TABLE tblDVD    PK ID INT AUTO INCREMENT NOT NULL   Title VARCHAR 100  NOT NULL   DIrector VARCHAR 100  NOT NULL   Genre VARCHAR 40  NOT NULL   dvd Year YEAR NOT NULL   Price FLOAT 2  NOT NULL   Quantity INT NOT NULL   PRIMARY KEY  PK ID       Any help in fixing the will be greatly appreciated as it will help me with my A2 computing lesson

User · Accepted Answer

You have an error in your OrderQuantity column. It is named "OrderQuantity" in the INSERT statement and "OrderQantity" in the table definition.

Also, I don't think you can use NOW() as default value in OrderDate. Try to use the following:

 OrderDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Example Fiddle

User · Answer

I had this error aswell   I am working in mysql workbench  When giving the values they have to be inside     That solved it for me

[mysql] MySQL error #1054 - Unknown column in 'Field List'

Examples related to mysql

Examples related to mysql-error-1054