How to load data from a text file into a table?
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 5 r's of managing behaviors?
Explain about the architecture of MYSQL?
What are the mysql database files stored in system ?
Which datatype is used for email in mysql?
How can I see mysql database?
What is deterministic in mysql?
What is logs in mysql?
Where is mysql data stored linux?
Can you tell the difference between ereg_replace() and eregi_replace()?
Differentiate CHAR_LENGTH and LENGTH?
What you can use regular expression for in mysql? Support your answer with an example?
What storage engines are used in MySQL?
What is mysql architecture?
What is the use of concat() in mysql?
How can I connect mysql database?