Re: [DB] Problem with DELETE TABLE

From: Date: Mon, 08 Mar 2004 20:19:18 +0000
Subject: Re: [DB] Problem with DELETE TABLE
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-11162@lists.php.net to get a copy of this message
Hi Am Mo, 2004-03-08 um 21.11 schrieb Lorenzo Alberton: > On Mon, 08 Mar 2004 20:54:48 +0100, Marco Schuler wrote: > > Hi > > I have this code to process with an easy sql-statement: > > > > $sql = 'DELETE TABLE users'; > > > try with "DELETE FROM users" if you want to empty > the table, or with "DROP TABLE users" if you want to remove > the table Oops, that was a copy-past-error! I was trying something different and coppied the wrong line. "DELETE FROM users" does not work too. :-( ErrMsg: DB Error: syntax error UsrMsg: 'DELETE FROM users' [nativecode=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 ''DELETE FROM users'' at line 1] Any hints? -- Grüsse Marco

« previous php.pear.general (#11162) next »