Error #1064 in mySQL Query
Posted
by William
on Stack Overflow
See other posts from Stack Overflow
or by William
Published on 2010-03-28T16:18:09Z
Indexed on
2010/03/28
16:33 UTC
Read the original article
Hit count: 155
I get the following error in the query below:
#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 ')))' at line 1
Code Snippet:
INSERT INTO test_bans( ip, Expiration )
VALUES (
"0.0.0.0", DateAdd(
"d", 1, Date( )
)
)
Table creation query
CREATE TABLE test_bans (
ID smallint(6) NOT NULL AUTO_INCREMENT,
IP text NOT NULL,
Expiration DATETIME NOT NULL,
PRIMARY KEY (ID)
) TYPE=MyISAM;
What am I missing?
© Stack Overflow or respective owner