Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15655 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 is the purpose of using timestamp data type?
What is identity in mysql?
What is use command in mysql?
What is RMS Migrations
What is save point in mysql?
How to copy data from one server to another using php?
How do I stop a mysql command?
How do I show all mysql databases?
How to escape special characters in sql statements?
What is the data source name for mysql?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
Why mysql is open source?
What are enums used for in mysql?
What are ddl statements in mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?
