How to execute SQL command with parameters in bash script

Question

I would like to make a bash script which will add user to my custom table in MySQL database. I have username as script argument stored in variable $USERNAME and I need to execute this query into MySQL server:

INSERT INTO `user` VALUES ('$USERNAME', password)

I know how to execute a sql file but that won't help me when I have username in variable. The only way I can think of is to execute php file with GET values and execute sql command in php. And I'm not eve sure that with php will work as I think.

Is there any better way?

Thanks

EDIT: After your helpfull answers I went with this command which works:

mysql -ppassword --default-character-set=utf8 -e "INSERT INTO table VALUES (\"$USERNAME@\",\"password\")" database

Are you familiar with mysql -e "command"? In your case, mysql -e "INSERT INTO user VALUES ('$USERNAME', password) — fedorqui
– fedorqui, Commented Mar 17, 2014 at 16:14
I wasn't familiar with mysql command but now I am. Thanks for tip — e_scape
– e_scape, Commented Mar 18, 2014 at 12:26

Josh Jolly · Accepted Answer · 2014-03-17 16:22:11Z

1

You could try using a heredoc:

#!/bin/bash

USERNAME="example"

mysql <<MYSQL
INSERT INTO user VALUES ('$USERNAME', password);
MYSQL

edited Mar 17, 2014 at 16:22

answered Mar 17, 2014 at 16:15

Josh Jolly

11.9k3 gold badges41 silver badges57 bronze badges

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

1 Comment

e_scape Over a year ago

I didn't know about heredoc before. I looked it up and it seems good but I'll use it on some more difficult queries.

hjpotter92 · Accepted Answer · 2014-03-17 16:15:07Z

0

The command would be:

mysql -pyourpasswordwithoutspaces -e "Your insert query goes here with semicolon;"

I'm not sure if the semicolons are necessary or not, but it always good to provide them.

answered Mar 17, 2014 at 16:15

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

Collectives™ on Stack Overflow

How to execute SQL command with parameters in bash script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related