slzdevsnp
8/29/2019 - 5:27 PM

[sqlite3] #sql #sqlite

[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