You can simply use as follows. mysql -h <hostname> -u <user nam

How Connect to a Database in Shell Programming?

Question Posted / sibin kc

Answer Posted / sibin kc

You can simply use as follows.

mysql -h <hostname> -u <user name> -p<password> -e "use
psa;select * from domains where domain_name = 'hai.com';"

Is This Answer Correct ?

9 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Calculate a real number calculation directly from the terminal and not any shell script.

1147

What are the different variables present in linux shell?

1038

How can you find out how long the system has been running?

844

Why is it called a shell?

878

How will you find the 99th line of a file using only tail and head command?

2476

Print a given number, in reverse order using a shell script such that the input is provided using command line argument only.

1110

What are the different communication commands available in the shell?

908

What is bash coding?

865

What is a batch file used for?

1026

How to pass an argument to a script?

1088

What is the use of a shebang line?

1106

Is cmd a shell?

954

Explain about stdin, stdout and stderr?

1099

how to print the matrix form of 2-d, 3-d arrays in unix c shell scripts ?

4015

Can we run shell script in windows?

1055