[sqlite3] #sql #sqlite
#ref file
~/GoogleDriveSlzdev/zrepos/slzdevsnp/learn/compsci/sql/uddl/lagunita_widom
# created sqlite schemas in
~/Documents/dbsqlite/schema_ddl/
# same folder copied to
~/Dropbox/dbsqlite/
# how to create a sqlite db from a ddl.sql
>sqlite3 -init schema_ddl.sql ~/Documents/dbsqlite/schema.db
#see databases , objects
$sqlite3 ~/Documents/dbsqlite/pizza.db
sqlite>.databases
sqlite>.tables
sqlite>select * from tablename;
sqlite>.exit
sqlite>.q