Select * query considering all files in the directory - Shell script

Question

I have a SQL query :

insert into table1 select * from table2

I have to execute this query via shell script which i'm doing in following way:

read -d '' QUERY <<EOF
insert into table1 select * from table2;
EOF

The if i do echo $QUERY it prints all files in the directory and that's why this insert is failing. Is there a way i can still use * without shell referencing it to files within that directory?

Put it in double quotes: `echo "$QUERY"` – Arkadiusz Drabczyk Sep 21 '22 at 20:08 — Arkadiusz Drabczyk, Sep 21 '22 at 20:08
It must be a duplicate – Arkadiusz Drabczyk Sep 21 '22 at 20:09 — Arkadiusz Drabczyk, Sep 21 '22 at 20:09
put in quotes the first `EOF` – Jetchisel Sep 21 '22 at 21:23 — Jetchisel, Sep 21 '22 at 21:23

score 1 · Accepted Answer · answered Sep 21 '22 at 20:10

The shell globbing on * would be happening wherever you're using $QUERY. Apply quotation marks to wherever you might be using $QUERY.

Better to simply pipe the SQL statement into mysql or whatever it is.

echo "insert into table1 select * from table2" | mysql

Select * query considering all files in the directory - Shell script

1 Answers1