List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 30 2008 1:14pm
Subject:Re: feature request: statement SELECT...(INSERT|UPDATE) :)
View as plain text  

> On Jan 30, 2008 12:50 PM, Dmitry E. Oboukhov wrote:
> > Is it possible to add to the syntax of the INSERT operator appoximately
> > in such way:
> > SELECT list INSERT [IGNORE] INTO ... - an added one.
> > SELECT list UPDATE .... - an added one.
> 
> > PS: I understand that adding the changes into a language is a very
> > serious question that needs a great discussion but one never can tell,
> > may be mysql developers will be interested in my proposal ;)
> 
> I think it would be a good idea to look at the way other databases can
> do this and see if there is some common syntax that could also be
> implemented by MySQL. For instance PostgreSQL implements a INSERT /
> UPDATE / DELETE ... RETURNING ... statement. ISTM that is exactly the
> functionality you want, but with a different syntax. If there are no
> other (better) competing implementation syntaxes (I don't know any,
> but maybe other list members do), I would like MySQL to adopt the
> PostgreSQL example.

Firebird uses this syntax as well, I believe it's the SQL standard syntax
for this feature.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Thread
feature request: statement SELECT...(INSERT|UPDATE) :)Dmitry E. Oboukhov30 Jan
  • Re: feature request: statement SELECT...(INSERT|UPDATE) :)Jochem van Dieten30 Jan
  • Re: feature request: statement SELECT...(INSERT|UPDATE) :)Martijn Tonies30 Jan