Into

SELECT INTO

Into table

    alasql('SELECT * INTO City FROM Capital');

Into external file (into-functions)

    alaslq('SELECT * INTO CSV(‘city.csv’) FROM City');

Into stdout (for Node.js):

    alasql('SELECT * INTO TXT() FROM City');

Into-functions

• TXT()
• JSON()
• CSV()
• TSV() / TAB()
• XLSX()
• HTML()

Examples:

    alasql('SELECT * INTO AfrikanCountries FROM Countries WHERE Country = "Afrika"');

    alasql('SELECT * INTO TXT("cities.txt") FROM cities');

Data format conversion (from XLSX to CSV):

    alasql('SELECT * INTO CSV("parts.csv") FROM XLSX("parts.xlsx") WHERE Qty > 10');