mysql - 我在尝试创建表时不断收到 mysql 中的 1064 错误

Question

CREATE TABLE company.employee(

     'fname' VARCHAR(15) NOT NULL,
     'mname' CHAR NULL,
     'lname' VARCHAR(15) NOT NULL,
     'ssn' CHAR(9) NOT NULL,
     'bdate' DATE,
     'Address' VARCHAR(35) NOT NULL,
     'Sex' CHAR NULL,
     'Salary' DECIMAL (10,2) NULL,
     'Super_ssn' CHAR(9) NULL,
     'Dnumber' INT NOT NULL,
     PRIMARY KEY('ssn')
     )

错误：

Error Code: 1064. 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 ''fname' VARCHAR(15) NOT NULL,
 'mname' CHAR NULL,
 'lname' VARCHAR(15) NOT NULL,
 '' at line 2   0.016 sec

标签： mysqlparsingsyntax-errormysql-error-1064