Interested to Buy Any Domain ? << Click Here >> for more details...
How Connect to a Database in Shell Programming?
- 4 Answers
- 24753 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 do you schedule a command to run at 4:00 every morning?
what is the difference between sh & bash shell?
How to calculate the number of passed arguments?
How to take input values from the user?
How to get the 3rd element/column from each line from a file?
how to read systems current date and time
Calculate a real number calculation directly from the terminal and not any shell script.
What is the command for " how many shell is running in your system or how many shell supported by your system " ?.
What is the use of "$#" in shell scripting?
How to include comments in your shell scripts?
How can you find out how long the system has been running?
What does $1 mean in bash?
ASP 
