List:General Discussion« Previous MessageNext Message »
From:Tim Dunphy Date:December 2 2011 1:53am
Subject:delete syntax
View as plain text  
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
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