Answer Posted / nithya

use SQL LOADER.

type in ur command prompt:
> sqlldr

> sqlldr userid=user/password@DB_INSTANCE_NAME
control=import.ctl log=import.log data=import.csv

where u hav to convert ur text file into comma seperated
file(.csv) and ur control file must be:

load data

infile call_list.csv //data file

append

into table bck_up // db table name

fields terminated by ','

optionally enclosed by'"'

trailing nullcols
(
name,num,num2 //columns in ur text file.
)

Does mysql use tcp or udp?

876

---

What is horizontally scalable?

932

---

How does mysql clustering work?

853

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1036

---

How do I show all mysql databases?

926

---

Can python connect to mysql?

946

---

What is unique key in mysql?

932

---

What is difference between mongodb and mysql?

872

---

Is mysql good for large database?

869

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

864

---

What port is mysql running on?

879

---

What is cast in mysql?

845

---

What is latest version of mysql?

953

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2780

---

How can we get total number of records by query in mysql?

863

---