Hello: I am testing a new product with MySQL, and so far have been very pleased, especially with the performance. One enhancement that I was looking forward to in 4.0 is described below:
Updates that run over multiple tables is harder to do in MySQL. This will, however, be fixed in MySQL 4.0 with multi-table UPDATE and in MySQL 4.1 with subselects. In MySQL 4.0 one can use multi-table deletes to delete from many tables at the same time. See section 6.4.6 DELETE Syntax However, it appears the syntax for multi-table update has not been included in the version I just downloaded, 4.0.0a. Please advise as to when this will be available. I have several UPDATE queries that depend on multiple tables. Since you also do not yet support subselects, with the multi-table update I know of no way to port these queries to MySQL. Let me know if you have a suggestion to do this. Thanks for a great product, I look forward to using it exclusively in our new package. Mike Frederick WayCool Software, Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php