How to load data from a text file into a table?
- 7 Answers
- 14419 Views
- Sasaa, I also Faced
- E-Mail Answers
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
)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I create a new database in mysql?
What is the difference between mysql_connect and mysqli_connect?
What is 'mysqlimport'?
What is username in mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?
Is mysql a programming language?
How to represent ENUMs and SETs internally?
What are the features of mysql?
What is definer in mysql?
How do I connect to a database in mysql workbench?
Why use stored procedures in mysql?
How do I kill a mysql connection?
How large can a mysql database become?
How is oracle different from mysql?
Where is the mysql database stored?
