Hi ,
Thanks for reply
I had earlier downloaded mysql-4.1.1 development branch source code and had
noticed that This bug is also present in 4.1.1 development tree source code
I had downloaded mysql-4.0 development source code as mentioned in mysql
documentation but could not compile it as innodb
Hi ,
At present I am using phpMyAdmin for my mysql data management
Though it is an excellent front end interface , I feel the interface designed
for multitable select quiries by phpMyAdmin is not very good. It is faster to
write query by hand than generate the query by that interface
I have
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
I have update priviledge on all the tables mentioned in the query
I am able to update one table at time with the same connection
There is some more requirement or bug in mysql for multi-table update
Regards
Ajit
-
This mail sent through
Hi ,
Result for Show Grants is as under
SQL result
Host: localhost
SQL-query: SHOW GRANTS FOR aldixit@localhost;
Grants for aldixit@localhost
GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aldixit'@'localhost'
IDENTIFIED BY PASSWORD 'xx'
GRANT SELECT ON `mysql`.* TO