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 is table level locking in mysql?
Which is faster mysql or mongodb?
What is prepare statement in mysql?
How to list or view all databases from the mysql server.
What is a join in mysql?
What is mysql and why it is used?
How do I rename a procedure?
How to extract a unit value from a date and time?
What is delimiter $$?
What is the difference between mysql and pdo?
Can we save images in mysql database?
Can python connect to mysql?
What are the column comparisons operators?
If we use sum function in mysql, does it return sum of that row or for that column?
What is truncate in mysql?