Problem with SQL 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:23 UTC
Read the original article
Hit count: 176
sql
Here's the query
INSERT INTO test_bans( ip, Expiration )
VALUES (
"0.0.0.0", DateAdd(
"d", 1, Date( )
)
)
Here's the 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;
And here's the error
#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
Please help.
© Stack Overflow or respective owner