Interested to Buy Any Domain ? << Click Here >> for more details...
How Connect to a Database in Shell Programming?
- 4 Answers
- 24490 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to get the first line from a file using just the terminal?
What language is shell scripting?
What is the difference between bash and shell?
What are script files?
How do you debug a script?
Write a script to print the first 10 elements of fibonacci series.
How to pass an argument to a script?
how will you find the total disk space used by a specific user?
How can we find the process name from its process id?
Write down the syntax for all the loops in shell scripting.
How do I run a shell script on a mac?
how to print the 2-d, 3-d arrays in unix shell script programs please answer thi questio to my mail venusaikumar@gmail.com
Is scripting and coding the same thing?
What is shell and terminal?
on “sed” command EmpData(Sample Database) 1122|j.b. saxena |g.m. |account |12/12/52|6000 2233|n.k. gupta |d.g.m |sales |31/12/40|9000 4545|anil agarwal |director |account |06/07/47|7500 5656|lalit choudhury |executive|marketing|07/09/50|5000 1265|chanchal singhvi|g.m. |admin |12/09/63|6000 0110|shyam saksena |chairman |marketing|12/12/43|8000 5566|jai sharma |director |account |23/12/89|7000 7733|jayant |d.g.m |sales |29/02/70|6000 1. From the above database substitute the delimiter of first 3 lines with “ : “ 2. From the above database substitute the delimiter with “ : ” 3. Insert the string “ XYZ Employees” in the first line. 4. Store the lines pertaining to the directors, d.g.m and g.m into three separate files. 5. Using address store first 4 lines into a file Empupdate. 6. Find the pattern “account” in the database and replaces that with “accounts”. 7. Select those lines which do not have a pattern “g.m”. 8. Insert a blank line after every line in the database.
