sql error
| From: | Jule Slootbeek | Date: | Wed, 06 Nov 2002 02:36:30 +0000 |
| Subject: | sql error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-122909@lists.php.net to get a copy of this message | ||
I know this is the wrong mailinglist, but i don't want to subscribe to a second one for one random question.
when trying to enter this into my db:
DROP TABLE IF EXISTS dates;
CREATE TABLE dates (
id int(10) unsigned NOT NULL auto_increment,
date varchar(50) NOT NULL default '',
at varchar(50) NOT NULL default '',
where varchar(255) NOT NULL default '',
with varchar(255) NOT NULL default '',
whereURL varchar(100) NOT NULL default '',
info varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
(this is generated by phpMyAdmin)
i get this error:
ERROR 1064 at line 18: You have an error in your SQL syntax near 'where varchar(255) NOT NULL default '',
with varchar(255) NOT NULL default '',' at line 5
where's the error?
i don't see anything wrong..
TIA,
Jule
Jule Slootbeek
jslootbeek@clarku.edu