Open main menu

CDOT Wiki β

Changes

MAP524/DPS924 Lecture 6

69 bytes added, 17:06, 18 July 2015
Test data
** filename is names.txt
* Open database
<presource lang="bash">sqlite3 employee.db</presource>
* Set your deliminator
<presource lang="sql">.separator ","</presource>
* Import your data
<presource lang="sql">.import names.txt names</presource>
* Display your data
<presource lang="sql">select * from names;</presource>
* Quit
<pre>.quit</pre>