This method isn't ANSI-standard SQL, but Microsoft's Transact-SQL extension includes this handy feature. Creating a new table from query results can help you build a database of your clients ...

The SQLite CLI allows you to issue any valid SQL statements you like. To create SQLite database records, simply issue the appropriate SQL insert commands. Similarly, to list the records you simply ...