Interested to Buy Any Domain ? << Click Here >> for more details...
How Connect to a Database in Shell Programming?
- 4 Answers
- 24735 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashu
you have a "sqlplus" command to connect to database.
command is as follows:
sqlplus <db_username>/<db_password> @test.sql
| Is This Answer Correct ? | 19 Yes | 6 No |
Answer / 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 |
Answer / seshadri sethi
(1)1st give "sqlplus"
(2)then it will show "sqlplus" prompt
(3)give "db username"
(4)give "db password"
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / supraja
mysql -uusername -ppassword -hipaddress database -e "statement"
eg:mysql -uroot -psuppu -h192.168.0.1 supraja -e "select
count(*) from table"
| Is This Answer Correct ? | 2 Yes | 0 No |
How to initialize a directory size to a variable??
How to set an array in linux?
Is it possible to substitute "ls" command in the place of "echo" command?
What are the advantages of bash over all other shells?
What is the difference between a shell variable that is exported and the one that is not exported?
What is shell and terminal?
i have 2 tables 4 colums table 1 respective values a1 6, a2 8,a3 9,a4 14 & table 2 respective values a1 6, a2 8, a3 9, a4 12. if compare 2 tables 3 colums values same then 4th column values 1)Qes diff >5 then (5 * diff value ) 2)Qes diff <5 the 5 3)Qes diff 5 then 5 print respective values..
How do I open the shell in cmd?
What does $0 mean in shell script?
What is the syntax of while loop in shell scripting?
What are the different variables present in linux shell?
Determine the output of the following command: name=shubham && echo ‘my name is $name’.
ASP 
