Re: [DB] Problem with DELETE TABLE
| From: | Marco Schuler | 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