Mike Frederick writes:
> 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.
>
Hi!
Multi-table updates are comming in 4.0.2.
Syntax will be described in a manual when the above version is released.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
