if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 Answers  

---

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

4 Answers   Aufait, CSS, Wipro,

---

How do I show columns in mysql?

0 Answers  

---

How do I download mysql?

0 Answers  

---

Print 3 highest salary

9 Answers  

---

How to show table names with 'mysqlshow'?

0 Answers  

---

What is trigger in mysql with example?

0 Answers  

---

What are the types of database engines available in mysql?

0 Answers  

---

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

What data structure does mysql use?

0 Answers  

---

How do you restart mysql?

0 Answers  

---

Where is mysql data stored?

0 Answers  

---