MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:November 27 2002 4:04pm
Subject:re: re: re: Multi-Table Updates
View as plain text  
ajitdixit,
Wednesday, November 27, 2002, 7:04:51 AM, you wrote:

aasdcdi> Result for Show Grants is as under 

aasdcdi> SQL result

aasdcdi> Host: localhost

aasdcdi> SQL-query: SHOW GRANTS FOR aldixit@localhost;
aasdcdi> Grants for aldixit@localhost
aasdcdi> GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost'
aasdcdi> IDENTIFIED BY PASSWORD 'xxxxxxxxxxxxxx'
aasdcdi> GRANT SELECT ON `mysql`.* TO 'aldixit'@'localhost' WITH GRANT OPTION
aasdcdi> GRANT ALL PRIVILEGES ON `samir`.* TO 'aldixit'@'localhost' WITH GRANT OPTION

[skip]

aasdcdi> Multi-Table Update with user aldixit

aasdcdi> SQL-query : 

aasdcdi> update Stockists, areas set a_nm = aname WHERE area = acd

aasdcdi> MySQL said:

aasdcdi> update command denied to user: 'aldixit@localhost' for table 'areas'

Thanks for detailed bug report. I could repeat it on 4.0.5, but it
works perfectly on 4.0.6.

mysql> update Stockists, areas set a_nm = aname WHERE area = acd;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

Seems, this bug is already fixed.




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Multi-Table Updatesajitdixit26 Nov
  • re: Multi-Table UpdatesEgor Egorov26 Nov
    • re: Multi-Table Updatesajitdixit26 Nov
      • re: re: Multi-Table UpdatesEgor Egorov26 Nov
        • re: re: Multi-Table Updatesajitdixit27 Nov
          • re: re: re: Multi-Table UpdatesEgor Egorov27 Nov
            • re: re: re: Multi-Table Updatesajitdixit27 Nov
              • re: re: re: re: Multi-Table UpdatesEgor Egorov2 Dec