Hello.
On Mon, Mar 12, 2001 at 05:16:59PM -0600, [EMAIL PROTECTED] wrote:
> Seems like it would be relatively easy to implement inserting into merge
> tables. I'd like to be able to at an absolute minimum round-robin
> insert, but even better would be something like you can do with
> partitioning in oracle.
>
> Baically, something like this:
>
> create table x (...) type=merge union=(a,b,c,d)
> partition=a:(where key=val1) partition=b:(where key>val2 and key<val3);
[...]
While I completely agree that some sort of INSERT into MERGE tables
would be really nice (to avoid the need to change the program), I
don't see how this falls under "relatively easy to implement". MySQL
doesn't even have yet expressions as default values for columns. But
maybe you meant it another way.
For a first start I would suggest two variants, which shouldn't be to
hard to do, because no new specs are needed: round-robin, as you
suggested and first resp. last.
The latter one is needed for logging tables, where you want all new
rows go into the same table.
Bye,
Benjamin.
---------------------------------------------------------------------
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
