Useful things to know about MySQL 4

[Michael Daskalov]

Hi,
  about the following:
<quote>
	+ It has an expanded DELETE syntax that allows you to DELETE
from
multiple tables at once. I'm not sure how PostgreSQL is on this, but I
suspect it probably works equally well on PostgreSQL.
</quote>

I don't know about multiple deletes in PostgreSQL, but for sure they are
not supported in Oracle (and I think in DB2 and Sybase also),
so I propose to not use them, just because the new MySQL 4 supports
them.

Regards,
Mihail Daskalov

-----Original Message-----
From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org] On Behalf Of Max Kanat-Alexander
Sent: Sunday, July 10, 2005 10:01 PM
To: developers at bugzilla.org
Subject: Useful things to know about MySQL 4


	So, as many of us know, we will soon be requiring MySQL 4.0 for
Bugzilla to run. (Actually, at least 4.0.2 and perhaps some higher
version.)

	Here's a few things that are good to know about MySQL 4:

	+ It has a query cache, but it doesn't work for "server-side
prepared
statements," per the MySQL docs. I'm not quite sure how this works with
DBI, perhaps somebody else knows?

	+ It supports UNION. So does PostgreSQL, so we can use UNION if
it's
necessary or makes life simpler. I know that PostgreSQL basically treats
a UNION as two independent queries, performance-wise; I suspect MySQL
does the same, but I'm not sure how it will use indexes in a UNION.

	+ It has an expanded DELETE syntax that allows you to DELETE
from
multiple tables at once. I'm not sure how PostgreSQL is on this, but I
suspect it probably works equally well on PostgreSQL.

	If you aren't familiar with what any of these things are, feel
free to
ask me here or in IRC and I'll try to explain.

	There are also some other useful features in MySQL4. You can see
all
the changelogs here:

	http://dev.mysql.com/doc/mysql/en/news-4-0-x.html

	-Max
-- 
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.

-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=MDaskalov@technologica.biz>