Running direct SQL statements using a batch file

Question

How can I run SQL statements in a batch file, without reading the statement in a text file?

For sqlplus from windows cmd prompt you are limited to piping in the text: something like: echo select * from emp; | sqlplus user/password — Lord Peter, Dec 29 '12 at 07:46

score 2 · Answer 1 · answered Dec 29 '12 at 07:42

2

mysql -uUSERNAME -pPASSWORD db_name -e "SELECT whatever FROM table ..."

answered Dec 29 '12 at 07:42

Barmar

1 Answers1