How to load data from a text file into a table?
- 7 Answers
- 14547 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
What are the applications required to support mysql?
What is procedures in mysql?
What are date and time functions in mysql?
What is procedural api?
What is sharding in mysql?
Is mariadb better than mysql?
Is mysql a server or database?
What does "i_am_a_dummy flag" do in mysql?
What is an index? How can an index be declared in mysql?
Will mysql remain free?
What is use of mysql?
How can I compare two mysql databases?
What is the limitation of mysql?
How do I create a mysql username and password?
What is 'mysqlshow'?
