MYSQL ERROR 1064(42000)

Question

mysql> CREATE TABLE EMPLOYEE_PAY_TBL-> (-> EMP_ID VARCHAR(9) NOT NULL PRIMARY KEY，-> POSITION VARCHAR(15) NOT NULL,-> DATE_HIRE DATE,-> PAY_RATE DECIMAL(4,2),-> DATE_LAST_RAISE DATE,-> SALARY DECIMAL(8,2),-> BONUS DECIMAL(6,2),-> CONSTRAINT EMP_FK FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE_TBL (EMP_ID)-> );ERROR 1064 (42000): 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 'KEY，POSITION VARCHAR(15) NOT NULL,DATE_HIRE DATE,PAY_RATE DECIMAL(4,2),DAT' at line 3

Answer 1

KEY，换成 KEY,

关键是要理解语法，以及善于利用错误信息排查，这里已经告诉你了，错误在KEY附近，而不是照抄书上，否则那么多字哪里能抄对呢。