Answer Posted / tushar

To load the text file pet.txt into the pet table, use this statement:

mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

What is flush privileges in mysql?

996

---

What is mysql_connect?

950

---

How do you create a schema?

953

---

How can you take the backup and restore a mysql database using php?

960

---

How can I see connections in mysql?

921

---

can you elaborate on blob and text in mysql? : Mysql dba

895

---

What is dbms in mysql?

969

---

Does mysql automatically index foreign keys?

926

---

How to insert html code into mysql database using php?

1073

---

How many sql ddl commands are supported by 'mysql'?

1134

---

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

2228

---

Does mysql scale well?

892

---

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

908

---

How to run a sql statement?

1033

---

How to display nth highest salary from a table in a mysql query?

993

---