SQLite Import Text File into SQLite database as a table

Published: 06 April 2020
on channel: Cloud Security Training & Consulting
10,550
53

This is a short video to demonstrate how to import table from a flat file / text file into SQlite database.


Sqlite3
.mode csv
.separator " " [Default is comma]
.import customers.txt customers
.tables
.schema
.SELECT * from customers
.exit


On this page of the site you can watch the video online SQLite Import Text File into SQLite database as a table with a duration of hours minute second in good quality, which was uploaded by the user Cloud Security Training & Consulting 06 April 2020, share the link with friends and acquaintances, this video has already been watched 10,550 times on youtube and it was liked by 53 viewers. Enjoy your viewing!