Insert from SQL shell script

Question

Good evening

I am trying to insert data from one table to another in my script and it comes up with database not found - have I done something wrong?

mysql -e INSERT INTO mysql.db SELECT * from "$cpuser"_mysql.db;

CPUser is a variable manually assigned earlier in the script.

From the CLI I can select * from both

Output from comment;

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''domain7mysql4'_mysql.db' at line 1
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''domain7mysql4'_mysql.user' at line 1

nbk · Accepted Answer · 2023-01-31 08:48:25Z

1

-se expects a string, so you need to provide one

mysql -e "INSERT INTO mysql.db SELECT * from `${cpuser}_mysql`.db;"

or

mysql -e "INSERT INTO mysql.db SELECT * from ${cpuser}_mysql.db;"

if there are no reserved text

edited Jan 31, 2023 at 8:48

answered Jan 30, 2023 at 21:24

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

3 Comments

lukederbyshire Over a year ago

This appears to then show a sytax error - see edited post

nbk Over a year ago

i corrected my answer

chepner Over a year ago

Use ${cpuser}_mysql to avoid trying to expand a parameter named cpuser_mysql. The placement of the quotation marks in the original prevent this error.

Collectives™ on Stack Overflow

Insert from SQL shell script

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related