1,234
edits
Changes
→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>