run and execute text file using sqlite 3 command line

Question

I have a text file which contains an sqlite statment where I want to dump it into .sql format but not able to excute it. Any help would be appreciated. My file is stored on desktop as verbali.txt and when i go to command prompt and to specific sqlite folder and run it just open the text file .

.mode insert 
.header on
.out file.sql 
select select Id   ,CompanyId  ,DateTime  ,Serial  ,DeviceId  ,AgentAId  ,GpsAddress  ,Targa  ,CommonRoadDescription  ,RoadCivicNumber  ,VehicleBrandDescription  ,VehicleModelDescription  ,VerbaliVehicleTypeDescription  ,CommonColorVehicleDescription  ,VerbaliRuleOneCode  ,VerbaliRuleOneDescription  ,VerbaliRuleOnePoints  ,VerbaliClosedNoteDescription  ,Points  ,VerbaliMissedNotificationDescription  ,MissedNotificationNote  ,StatementNote  from VerbaliData

laalto · Accepted Answer · 2014-01-16 11:48:12Z

1

Pipe the file to sqlite3, in command prompt:

sqlite3 yourdatabase.db <path\to\verbali.txt

where sqlite3 is the sqlite3.exe command line tool.

edited Jan 16, 2014 at 11:48

answered Jan 16, 2014 at 9:59

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

preethi Over a year ago

can you tell me where i am going wrong. C:\programfiles<x86>\sqlite expert\personal 3> sqlitexpertpers.exe and then type in the following right webmobility.db<c:\verbali.txt

preethi Over a year ago

when I try to run your command after the database it opens the sqlite database again I cant find the file

preethi Over a year ago

is it possible to create a sql file from sqlite command prompt.

Collectives™ on Stack Overflow

run and execute text file using sqlite 3 command line

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related