Technical notes‎ > ‎

Working with databases

posted Jan 12, 2016, 12:18 AM by Le Tuan Anh   [ updated May 15, 2017, 8:54 PM ]

SQLite

Execute a script file

Executing a script file $sqlite3 dbfile.db < scriptfile.sql
Executing a command echo "SELECT * FROM atable" | sqlite3 dbfile.db

MySQL


Lorem ipsum

PostgreSQL


Lorem ipsum
Comments