> I've recently learned that Oracle has the ability to partition table
> data, Oracle9i's list partitioning feature.

> http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html

> I'm trying to find out if MySQL or any open source database has
> something equivalent to this.

See the MySQL MERGE TABLE type - http://www.mysql.com/doc/en/MERGE.html

You have to allocate inserts to different "partitions" in your application,
but you can merge many partition tables into one for the purpose of SELECT,
DELETE, and UPDATE.

      Alec



---------------------------------------------------------------------
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

Reply via email to