MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:November 26 2002 11:35am
Subject:re: Multi-Table Updates
View as plain text  
Tuesday, November 26, 2002, 10:33:04 AM, you wrote:

aasdcdi> I am using mysql-4.0.5a-beta on Linux Redhat 7.3 server with php-4.3.0RC1

aasdcdi> When I connect and execute my quiries as root user my query of multi-table
aasdcdi> update works fine

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

aasdcdi> Query Executed OK , one row affected

aasdcdi> The Query results are OK

aasdcdi> But when I execute the same query with different user having update and lock
aasdcdi> table previledges I get error

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

aasdcdi> What previledges are required for user to execute multi-table update?

You must have UPDATE privilege on all tables mentioned in the UPDATE

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

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