Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Using SELECT to INSERT records [moved] #915

Closed
lvca opened this Issue Dec 10, 2012 · 0 comments

Comments

Projects
None yet
1 participant
Owner

lvca commented Dec 10, 2012

This is Issue 915 moved from a Google Code project.
Added by 2012-06-27T19:29:09.000Z by vaclav.s...@gmail.com.
Please review that bug for more context and additional comments, but update this bug.

Original labels: Type-Enhancement, Priority-Low, v1.4.0

Original description

It would be great having a way to use SELECT results in INSERT statements, e.g. for bulk inserts as a data migration.

the statement could be as follows:

insert into x(user) values (select from ouser where name = 'admin')
or
insert into x(user) values (select @rid from ouser where name = 'admin')

@lvca lvca closed this Oct 2, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment