Select Code to Download

BEGIN TRANSACTION;
CREATE TABLE `animal` (
...
  SELECT id,name
  FROM animal
  WHERE type='cat';

$sqlite3 animal.sqlite '.read animal.sql'

$ sqlite3 -header -column animal.sqlite 
SQLite version 3.11.0 2016-02-15 17:29:24
...
2           Sylvester 
3           Garfield  
sqlite> .q