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: 139

Filed under:
|

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

Related posts about sql

Related posts about mysql