Stupid dumb question about mySQL Im sure.
| From: | Liz Kimber | Date: | Wed, 10 May 2000 13:37:11 +0000 |
| Subject: | Stupid dumb question about mySQL Im sure. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10@lists.php.net to get a copy of this message | ||
OK, I have a table, such as
CREATE TABLE logfile (
Address varchar(255) NOT NULL,
GroupID varchar(20) NOT NULL,
UserID varchar(20) NOT NULL,
AccessDate varchar(40) NOT NULL,
Cmd varchar(255) NOT NULL,
RetCode varchar(4) NOT NULL,
Size varchar(20) NOT NULL,
Referer varchar(255) NOT NULL,
Browser varchar(255) NOT NULL,
KEY Address (Address),
KEY GroupID (GroupID),
KEY UserID (UserID),
KEY AccessDate (AccessDate),
KEY Cmd (Cmd),
KEY RetCode (RetCode),
KEY Size (Size),
KEY Referer (Referer),
KEY Referer_2 (Referer),
KEY Browser (Browser)
);
OK, so why does the following line not work.
delete FROM logfile WHERE Browser="somebrowser"
I dont get it.
I need to strip out some stuff, the file is getting too big