How do I import sql files into SQLite 3

Question

I have  sql files which have the following content    cat db sql create table server name varchar 50  ipaddress varchar 15  id init  create table client name varchar 50  ipaddress varchar 15  id init    How do I import this file into SQLite so that these are created automatically

User · Accepted Answer

From a sqlite prompt   sqlite gt   read db sql   Or   cat db sql   sqlite3 database db   Also  your SQL is invalid - you need   on the end of your statements   create table server name varchar 50  ipaddress varchar 15  id init   create table client name varchar 50  ipaddress varchar 15  id init

User · Answer

You can also do    sqlite3 database db -init dump sql

User · Answer

Use sqlite3 database sqlite3  lt  db sql  You ll need to make sure that your files contain valid SQL for SQLite

User · Answer

Alternatively  you can do this from a Windows commandline prompt batch file   sqlite3 exe DB db   read db sql    Where DB db is the database file  and db sql is the SQL file to run import

[sql] How do I import .sql files into SQLite 3?

Examples related to sql

Examples related to sqlite