Hi!

On Aug 13, 2008, at 4:06 PM, Baron Schwartz wrote:

How about inserting and getting the result back at the same time?
(Postgres does this already)  Or inserting into two tables at once?

I have spoken to JoshB about this one. I have a patch for 3.23 that allows you to get a RETURN on a DELETE. AKA use MySQL has a queue (this was a patch I did for a particular wireless carrier for their SMS system).

It is on the list for me to add. I had not considered INSERT, but it would be easy to do. Same for UPDATE.

data archiving -- DELECT FROM foo INTO foo_archive WHERE ....")


Yep, we could do it. If we got the above in, then it would be simple to do INSERT INTO/CREATE TABLE syntax like we now have for SELECT.

This would make for a good little project for someone.

Cheers,
        -Brian

--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.




_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to