Automate user input for Batch file

Question

I am looking to have a batch file login to a database for me and the execute 4 commands.

So here is what I have so far...

@echo off 
Echo "password" | config -c && 13 && 14 && 3
pause 
exit

So what I need this to do is to automatically accept my password as the first user input, the 13 as the second, the 15 as the third, and the 3 as the forth. Any advice or input is appreciated.

Which database engine are you using? SQL Server and MySQL already have command line tools which can do just what you want. — Jason Faulkner
– Jason Faulkner, Commented Mar 5, 2015 at 18:11

JosefZ · Accepted Answer · 2015-03-05 22:38:49Z

1

I do not know what is right syntax for your config command and whether accepts piped input or not, but

Echo "password" | config redirects to your config command all the string "password" including double quotes and trailing space (yes, that space before |); use Echo(password|config instead (no, echo( with opening parenthesis is not a keying mistake).
In the link thereinbefore, note && (doubled ampersand) meaning and check thoroughly config -c && 13 && 14 && 3 command in that point of view.
Read how-to escape characters (and particularly Escaping the pipeline paragraph).

HTH

answered Mar 5, 2015 at 22:38

JosefZ

30.5k6 gold badges52 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

Automate user input for Batch file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related