List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:December 2 2011 2:03am
Subject:Re: delete syntax
View as plain text  
delete from mysql.user where user='mail_admin';

Krishna

On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy <bluethundr@stripped> wrote:

> hello list,
>
>  I am attempting to delete a user from the mysql.user table  without
> success.
>
>  mysql> delete from mysql.user where user='mail_admin@%';
> Query OK, 0 rows affected (0.00 sec)
>
>
>  mysql> select user,host from mysql.user where user='mail_admin';
> +------------+-----------------------+
> | user       | host                  |
> +------------+-----------------------+
> | mail_admin | %                     |
>
>
>
>  I would appreciate any advice you may have.
>
>  Regards,
> Tim
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
delete syntaxTim Dunphy2 Dec
  • Re: delete syntaxKrishna Chandra Prajapati2 Dec
    • Re: delete syntaxTim Dunphy2 Dec
      • Re: delete syntaxShiva2 Dec
        • Re: delete syntaxReindl Harald2 Dec
          • Re: delete syntaxStdranwl2 Dec
            • Re: delete syntaxReindl Harald2 Dec
              • Re: delete syntaxClaudio Nanni2 Dec
                • Re: delete syntaxReindl Harald2 Dec
                  • Re: delete syntaxGovinda2 Dec
                    • How to get a specific number of entries per one key ?Blog Tieng Viet3 Dec
                      • Re: How to get a specific number of entries per one key ?Arthur Fuller3 Dec
                        • Re: How to get a specific number of entries per one key ?Rik Wasmus5 Dec
    • Re: delete syntaxKeith Keller2 Dec