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
Explain the difference between mysql and mysql interfaces in php?
How do I use mysql?
How many ways we can retrieve the date in result set of mysql using php?
How can you change the name of any existing table by using the sql statement?
What is row?
What do you understand by mysql terminal?
What are the differences between innodb and myisam engines?
Which statement is used in a select query for partial matching?
What is data types in mysql?
How can I insert images into a Mysql database?
How to get a list of indexes of an existing table?
How do I create a database in mysql workbench?
How to create table show example
What is difference between mysql and mysql workbench?
How to analyze tables with 'mysqlcheck'?