Answer Posted / ramesh

We can load the data to the table in 3 ways.
One is by using controle file
Second one is command Prompt And
Third one is by using apps concurrent program.
1)Load data
infile *
fields terminated by ','
insert into table table name
(
col1 datatype1
)

What can you do with mysql?

1004

---

How show all tables in mysql query?

916

---

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

958

---

What is bigint in mysql?

908

---

What are all the Common SQL Function?

1121

---

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

901

---

What are the difference between now and current_date in mysql?

1412

---

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

877

---

How to display odd rows in student table in mysql?

993

---

What is mysql command line?

1048

---

What is blob and clob?

943

---

What is difference between pdo and mysqli?

968

---

Does mysql support sequence?

935

---

How to use sum function in where clause in mysql?

957

---

How to enter Characters as HEX Numbers?

1005

---