How to load data from a text file into a table?
- 7 Answers
- 14448 Views
- Sasaa, I also Faced
- E-Mail Answers
Answer Posted / nithya
use SQL LOADER.
type in ur command prompt:
> sqlldr
> sqlldr userid=user/password@DB_INSTANCE_NAME
control=import.ctl log=import.log data=import.csv
where u hav to convert ur text file into comma seperated
file(.csv) and ur control file must be:
load data
infile call_list.csv //data file
append
into table bck_up // db table name
fields terminated by ','
optionally enclosed by'"'
trailing nullcols
(
name,num,num2 //columns in ur text file.
)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of myisam over innodb?
Is mysql good for big data?
How does triggers work in mysql?
Why mysql is so popular?
Explain the architecture models of SQL Server?
How do I zip a file in mysql?
Can mysql scale horizontally?
How do I declare a variable in mysql?
What is full form of xampp?
What is myisam?
What is meant by sharding?
How do I setup a mysql database?
what is database white box testing? : Mysql dba
What is definer in mysql?
What are procedures in mysql?
