hi there,

i want to insert bulkly using insert select in mysql.

how to "insert select from" in mysql ?

regards and thanks

Hi,

Did you check this component? or you can try and use an advance query with something like this:

INSERT INTO table_name(column_list)

SELECT    select_list 

FROM    another_table 

WHERE   condition;

Regards,

Marcelo

if you are in the .NET version you can use this component https://www.outsystems.com/forge/component-overview/1117/bulkinsert that does exactly what you want.

Thanks all,

I use java stack

Can we use just query advance? Tq

Hi,

You should be able to do it the way I told but to be honest I didn't try it. Give it a try and let us know how it goes.

Regards,

Marcelo

Solution

it work like this:

"insert into {aggregatename}(colomnname)
SELECT tbl.colomnname
from {aggregatename} tbl
where id = 1"

Solution