mysql - 无法解决 MySQL 错误 #1064

Question

据我所知，我的查询似乎没问题:

CREATE TABLE PORTAL_NOTES (
    id numeric NOT NULL,
    school_id numeric,
    syear numeric(4,0),
    title character varying(255),
    content character varying(5000),
    sort_order numeric,
    published_user numeric,
    published_date timestamp(0),
    start_date date,
    end_date date,
    published_profiles character varying(255)
);

但我收到此错误:

#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 '(1) , start_date date, end_date date, published_profiles characte' at line 9

谁能帮我调试这里的问题吗？

Answer 1

试试这个:

CREATE TABLE PORTAL_NOTES (
    id numeric NOT NULL,
    school_id numeric,
    syear numeric(4,0),
    title character varying(255),
    content character varying(5000),
    sort_order numeric,
    published_user numeric,
    published_date timestamp,
    start_date date,
    end_date date,
    published_profiles character varying(255)
);

问题是因为您在 timestamp(0) 中设置了长度，这不需要长度。