MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:ajitdixit Date:November 26 2002 8:33am
Subject:Multi-Table Updates
View as plain text  

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

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

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

Query Executed OK , one row affected

The Query results are OK

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

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

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

Regards

Ajit Dixit

-------------------------------------------------
This mail sent through http://shreya.co.in/
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