[mysql] org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into ~]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

    ๊ธฐ๊ป ๋‹ค ๋งŒ๋“ค์–ด๋†จ๋”๋‹ˆ ์˜ˆ์•ฝ์–ด๋ž‘ ๊ฒน์ณ์„œ ์—๋Ÿฌ๋‚ฌ๋‹ค.. ์ •๋ง ํ™”๊ฐ€๋‚œ๋‹ค.

    ํ•˜ ................ desc ์ฃผ์˜ํ•˜๊ธฐ! 

     

    MySQL์˜ ์˜ˆ์•ฝ์–ด.

    ADD ALL ALTER
    ANALYZE AND AS
    ASC ASENSITIVE BEFORE
    BETWEEN BIGINT BINARY
    BLOB BOTH BY
    CALL CASCADE CASE
    CHANGE CHAR CHARACTER
    CHECK COLLATE COLUMN
    CONDITION CONSTRAINT CONTINUE
    CONVERT CREATE CROSS
    CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
    CURRENT_USER CURSOR DATABASE
    DATABASES DAY_HOUR DAY_MICROSECOND
    DAY_MINUTE DAY_SECOND DEC
    DECIMAL DECLARE DEFAULT
    DELAYED DELETE DESC
    DESCRIBE DETERMINISTIC DISTINCT
    DISTINCTROW DIV DOUBLE
    DROP DUAL EACH
    ELSE ELSEIF ENCLOSED
    ESCAPED EXISTS EXIT
    EXPLAIN FALSE FETCH
    FLOAT FLOAT4 FLOAT8
    FOR FORCE FOREIGN
    FROM FULLTEXT GRANT
    GROUP HAVING HIGH_PRIORITY
    HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND
    IF IGNORE IN
    INDEX INFILE INNER
    INOUT INSENSITIVE INSERT
    INT INT1 INT2
    INT3 INT4 INT8
    INTEGER INTERVAL INTO
    IS ITERATE JOIN
    KEY KEYS KILL
    LEADING LEAVE LEFT
    LIKE LIMIT LINES
    LOAD LOCALTIME LOCALTIMESTAMP
    LOCK LONG LONGBLOB
    LONGTEXT LOOP LOW_PRIORITY
    MATCH MEDIUMBLOB MEDIUMINT
    MEDIUMTEXT MIDDLEINT MINUTE_MICROSECOND
    MINUTE_SECOND MOD MODIFIES
    NATURAL NOT NO_WRITE_TO_BINLOG
    NULL NUMERIC ON
    OPTIMIZE OPTION OPTIONALLY
    OR ORDER OUT
    OUTER OUTFILE PRECISION
    PRIMARY PROCEDURE PURGE
    READ READS REAL
    REFERENCES REGEXP RELEASE
    RENAME REPEAT REPLACE
    REQUIRE RESTRICT RETURN
    REVOKE RIGHT RLIKE
    SCHEMA SCHEMAS SECOND_MICROSECOND
    SELECT SENSITIVE SEPARATOR
    SET SHOW SMALLINT
    SONAME SPATIAL SPECIFIC
    SQL SQLEXCEPTION SQLSTATE
    SQLWARNING SQL_BIG_RESULT SQL_CALC_FOUND_ROWS
    SQL_SMALL_RESULT SSL STARTING
    STRAIGHT_JOIN TABLE TERMINATED
    THEN TINYBLOB TINYINT
    TINYTEXT TO TRAILING
    TRIGGER TRUE UNDO
    UNION UNIQUE UNLOCK
    UNSIGNED UPDATE USAGE
    USE USING UTC_DATE
    UTC_TIME UTC_TIMESTAMP VALUES
    VARBINARY VARCHAR VARCHARACTER
    VARYING WHEN WHERE
    WHILE WITH WRITE
    XOR YEAR_MONTH ZEROFILL

    ์ถœ์ฒ˜: https://henerd.tistory.com/24 [์ฝ”๋”์˜ ํ”์ :ํ‹ฐ์Šคํ† ๋ฆฌ]

    ๋ฐ˜์‘ํ˜•

    '๐Ÿšข PROJECTS > ๐Ÿ’พ Database' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

    [phpmyadmin] image ๋„ฃ๊ธฐ (์ž‘์„ฑ์ค‘)  (0) 2022.08.11

    ๋Œ“๊ธ€