Interested to Buy Any Domain ? << Click Here >> for more details...
How Connect to a Database in Shell Programming?
- 4 Answers
- 24739 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 change our default shell?
How to add some content in any file at some desired location without using VI or some other editor in UNIX
Why is shell scripting important?
In my bash shell I want my prompt to be of format '$"present working directory":"hostname"> and load a file containing a list of user-defined functions as soon as I log in, how will you automate this?
What are the different types of variables used in shell script?
What is the first line of a shell script called?
What are the various stages of a linux process it passes through?
What are the different types of commonly used shells on a typical linux system?
Write a shell program to test whether a given number is even or odd?
What is the command to find out today's date?
Calculate a real number calculation directly from the terminal and not any shell script.
What's the difference between scripting and coding?
ASP 
