Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15656 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
Is foreign key indexed mysql?
How to do login in mysql with unix shell.
How do I install mysql on windows 7?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How do I copy a table in mysql?
explain GROUPBY & HAVING clause with examples.
How can you change the name of any existing table by using the sql statement?
How we can create index in mysql?
What is csv?
What are queries used for?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What are the advantages of mysql in comparison to oracle?
How does limit work in mysql?
Explain the different types of mysql joins.
