Answer Posted / supraja

mysql -uusername -ppassword -hipaddress database -e "statement"

eg:mysql -uroot -psuppu -h192.168.0.1 supraja -e "select
count(*) from table"

How to get the first line from a file using just the terminal?

1054

---

What language is shell scripting?

971

---

What is the difference between bash and shell?

1059

---

What are script files?

970

---

How do you debug a script?

1000

---

Write a script to print the first 10 elements of fibonacci series.

2279

---

How to pass an argument to a script?

1092

---

how will you find the total disk space used by a specific user?

980

---

How can we find the process name from its process id?

1125

---

Write down the syntax for all the loops in shell scripting.

1077

---

How do I run a shell script on a mac?

1069

---

how to print the 2-d, 3-d arrays in unix shell script programs please answer thi questio to my mail venusaikumar@gmail.com

2517

---

Is scripting and coding the same thing?

933

---

What is shell and terminal?

931

---

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.

3047

---