DBMS March 15, 2021

mysql script in shell using variables

I would like to use mysql syntax in my shell scripts with variables, what am I using wrong ?

#!/bin/bash

mysql <MyBlaBlaDB> -e "select * from table where something = &1"

and I’m trying to run it as ./test.sh

Answer

try this way,

#!/bin/bash

something="anyting"
mysql -u [username] -p[password] [datbase name] -e "select * from table where something = $something"