mysql - 无法执行命令: MySQL

Question

create table `payrollmanagementsystem`.DEDUCTION
(
    CODE VARCHAR(50) not null primary key,
    NAME VARCHAR(50),
    SALARYPERDAY DOUBLE PRECISION,
    LEAVE INT,
    KWSP DOUBLE PRECISION,
    TOTALDEDUCTION DOUBLE PRECISION
)

我遇到了无法执行命令的问题，错误如下:

Unable to execute command:
create table `payrollmanagementsystem`.DEDUCTION
(
    CODE VARCHAR(50) not null primary key,
    NAME VARCHAR(50),
    SALARYPERDAY DOUBLE PRECISION,
    LEAVE INT,
    KWSP DOUBLE PRECISION,
    TOTALDEDUCTION DOUBLE PRECISION
)
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 'LEAVE INT,
    KWSP DOUBLE PRECISION,
    TOTALDEDUCTION DOUBLE PRECISION
)' at line 6

Answer 1

正如其他人指出的，LEAVE 是一个关键字。要解决您的问题，请使用反引号:

`LEAVE` INT,

请注意，CODE 也是一个关键字，但在这种情况下它不会导致问题。转义列名称仍然是一个好习惯。