Calling multiple commands in SQLite3 from Command Prompt

Question

I want to be able to make a batchfile that will loop through every file in a directory and import it inside SQlite3. The problem I have is that SQlite3 does not accept multiple commands from command prompt/batch, only 1 command.

What I have tried is :

 for %%f in (./tmp/*.csv) do (
     echo %%f
     sqlite3 database.db ".separator '|'" ".import './tmp/%%f' Dirs"
 )

And I get a too many options error, as it is only expecting a single command, while I need more than 1.

I also cannot write a second text file to be called by sqlite3 as the file being imported will change for every iteration.

Help would be appreciated.

CL. · Accepted Answer · 2013-04-12 18:52:23Z

4

You can use the option -separator to set the separator (whose default already is |).

If you'd really need to execute multiple commands, you could write them to a file and .read that, or echo all of them and pipe them into sqlite3.

answered Apr 12, 2013 at 18:52

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Comment

fysloc Over a year ago

Thanks, didn't realize the separator option.

Collectives™ on Stack Overflow

Calling multiple commands in SQLite3 from Command Prompt

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related