3 ms·
The tool has a flow: stdin -> spyql -> stdout You can choose the data format of the input and output. One of the output formats writes INSERT statements to stdo
by dmoura 5y ago
The tool has a flow: stdin -> spyql -> stdout
You can choose the data format of the input and output. One of the output formats writes INSERT statements to stdout, enabling to import data to any SQL database. Currently, spyql does not have the option to generate a `CREATE TABLE` statement, but that is planned, as well as what to do with already existing data/tables (e.g. drop, truncate, ignore).
I wonder if UPDATEs and UPSERTs would also be useful, but haven't put much though into it, any feedback here would be welcomed.