편집 기록

create table counters (
    sdate varchar(30),
    m_tel varchar(30), 
    r_number int,
    o_statement int,
    price int,
    PRIMARY KEY(sdate),
    FOREIGN KEY(m_tel) REFERENCES members(tel),
    FOREIGN KEY(r_number) REFERENCES rooms(number)
);

INSERT INTO counters (sdate, m_tel, r_number, o_statement, price)
    VALUES('2019.12.07', '010-2433-8483', 0, 1, 20250‬ );

위에는컬럼이고 아래는 입력값입니다. 참조값은 멤버,룸테이블에 추가되어있는값을 가져왔고 ' '도 잘맞춰서하는데

 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 '? )' at line 2

이에러가 뜨는데 도저히 머가문제인지 모르겠네요

create table counters ( sdate varchar(30), m_tel varchar(30), r_number int, o_statement int, price int, PRIMARY KEY(sdate), FOREIGN KEY(m_tel) REFERENCES members(tel), FOREIGN KEY(r_number) REFERENCES rooms(number) );

INSERT INTO counters (sdate, m_tel, r_number, o_statement, price) VALUES('2019.12.07', '010-2433-8483', 0, 1, 20250‬ );

위에는컬럼이고 아래는 입력값입니다. 참조값은 멤버,룸테이블에 추가되어있는값을 가져왔고 ' '도 잘맞춰서하는데 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 '? )' at line 2

이에러가 뜨는데 도저히 머가문제인지 모르겠네요