Using mysql in Batch Mode

Create a batch file by opening notepad and type:

select * from event;

Save it as a sql file

Open sql client and type:

source c:\mysql text\selectevent.sql

or you can use \.

\. c:\mysql text\selectevent.sql