Pass argument to mysql script from mysql client

Question

Is there a way/workaround/hack to pass an argument to a mysql script? Let's say I have a file name myqueries.sql which looks like this

SELECT * FROM FooBar where id = <arg>;

Then in mysql command, I know I can call this script by

mysql>source myqueries.sql

But is there a way to pass an argument here? Something like this:

mysql>source myqueries.sql 2

then I'd get the tuple with id = 2.

I've looked at that before, but it wouldn't work in my case since I can't launch mysql myself. let's say once I exit mysql, i can't go back. — 0x56794E
– 0x56794E, Commented Apr 5, 2013 at 0:00

Yusuke · Accepted Answer · 2015-12-28 03:37:58Z

1

myqueries.sql

SELECT * FROM FooBar where id = @arg;

on mysql

set @arg=2;
source myqueries.sql

answered Dec 28, 2015 at 3:37

Yusuke

1708 bronze badges

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

1 Answer 1