> I got problems deleting a user which I've created before.
>
> mysql> delete from user where user=wus;
> ERROR 1054: Unknown column 'wus' in 'where clause'
> mysql>
How about quoting a string type:
delete from user where user='wus';
-Lance
--
From: "Manuel Hendel" <[EMAIL PROTECTED]>
> I got problems deleting a user which I've created before.
>
> mysql> delete from user where user=wus;
> ERROR 1054: Unknown column 'wus' in 'where clause'
> mysql>
>
> Can anyone provide some help?
Try this:
delete from user where user='wus';
--
At 19:23 +0100 3/25/02, Manuel Hendel wrote:
>I got problems deleting a user which I've created before.
>
>mysql> delete from user where user=wus;
>ERROR 1054: Unknown column 'wus' in 'where clause'
>mysql>
>
>Can anyone provide some help?
wus is a string. Surround it in quotes.
>Thanks,
>
delete from user where user="wus";
-Original Message-
From: Manuel Hendel [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:24 PM
To: MYSQL List
Subject: problems deleting a user from "user" db
I got problems deleting a user which I've created before.
mysql> delete from user
