What does this error message mean for my query? "1064" How can I correct my query?

Discussion in 'MySQL' started by roachclip1986, Oct 26, 2011.

  1. #1
    This is my query

    
    DROP TABLE programmer CASCADE CONSTRAINTS;
    CREATE TABLE Programmer
    {
    EmpNo            Varchar2(3)        PRIMARY KEY,
    Last_Name         Varchar2(25)    NOT NULL,
    First_Name        Varchar2(25),
    Hire_Date        Date,
    Project            Varchar2(3),
    Language        Varchar2(15),
    TaskNo            Number(2),
    Clearance        Varchar2(25)
    );
    Code (markup):
    And this is the error message that prevents me from creating it:
    How can I correct this so that I can create my db using phpmyadmin? Thank you.
     
    roachclip1986, Oct 26, 2011 IP