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
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,
Manuel
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';
--
denonymous
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