INSERT INTO with SELECT

Kumar Majethia

Hi Any way to pull up a chunk of rows from one table to insert into another table? Hate to loop through stuff on a 4GL platform.

Ray Deck

There's a new "add multiple records in bulk" feature allowing you to pass an array of rows into an insert with a single transaction: https://docs.xano.com/working-with-data/functions/database-requests/clear-all-records-1. No more loops. 

(The link slug is misleading)

Kumar Majethia

 Awesome, thanks!