execute .sql file in bash with params

Question

I want to execute a .sql file in a bash file but I need to pass parameters to the .sql from the bash file. I think it's a simple solution but I can't figure it out.

This is what I have so far:

.SQL File

SET @columnValue = &1;
UPDATE tblTest SET Description = @columnValue;

Bash File

#!/bin/bash
columnValue=$1
mysql -uroot -ppassword testDB < SQLscript.sql $columnValue

Shell

sh myBashFile.sh "testColumnValue"

Can anyone tell me what i am doing wrong?

can you tell us what is currently happening?

ninesided
– ninesided

2014-10-15 08:39:24 +00:00
Commented Oct 15, 2014 at 8:39 — ninesided
– ninesided, Commented Oct 15, 2014 at 8:39

Community · Accepted Answer · 2017-05-23 11:57:09Z

1

You need a combination of setting SQL parameters first and then loading your .sql file.

In your bash script you can use mysql with the -e option to execute an SQL statement. The same method must then be used to tell mysql to load the file instead of reading it using bash.

See this example script.

If you only want to execute a single statement, see this question.

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Oct 15, 2014 at 8:56

andy

2,0021 gold badge12 silver badges21 bronze badges

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

2 Comments

Moenie Over a year ago

Your solution is working fine thank you!! :) So if i understand it correctly there is no way to pass params to a .sql file without setting mysql variable ?

andy Over a year ago

You could generate a bash script that replaces the variable tokens in your .sql file before handing it to mysql. However, I guess that would unnecessarily complicate things.

Collectives™ on Stack Overflow

execute .sql file in bash with params

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related