Re: problems deleting a user from "user" db

2002-03-25 Thread Lance Uyehara 

> 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




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problems deleting a user from "user" db

2002-03-25 Thread denonymous 

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
www.coldcircuit.net



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problems deleting a user from "user" db

2002-03-25 Thread Paul DuBois 

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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: problems deleting a user from "user" db

2002-03-25 Thread Rick Emery 

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 where user=wus;
ERROR 1054: Unknown column 'wus' in 'where clause'
mysql>

Can anyone provide some help?

Thanks,
Manuel

-- 
667: The neighbor of the beast. 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php