re: re: re: re: Multi-Table Updates

2002-12-02 Thread Egor Egorov
ajitdixit, Wednesday, November 27, 2002, 7:44:55 PM, you wrote: aasdcdi> I had earlier downloaded mysql-4.1.1 development branch source code and had aasdcdi> noticed that This bug is also present in 4.1.1 development tree source code Merge of 4.0.6 changes into 4.1 was made several days ago. aas

re: re: re: Multi-Table Updates

2002-11-27 Thread ajitdixit
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

re: re: re: Multi-Table Updates

2002-11-27 Thread Egor Egorov
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 TAB

re: re: Multi-Table Updates

2002-11-26 Thread ajitdixit
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 'aldixi

re: re: Multi-Table Updates

2002-11-26 Thread Egor Egorov
ajitdixit, Tuesday, November 26, 2002, 4:18:42 PM, you wrote: aasdcdi> I have update priviledge on all the tables mentioned in the query aasdcdi> I am able to update one table at time with the same connection aasdcdi> There is some more requirement or bug in mysql for multi-table update Show me