Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15356 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
How do you stop an access query?
Which statement is used to delete a table in MySQL.
What are the differences between innodb and myisam engines?
Where is the mysql data directory?
What does mysqli stand for?
What is field in mysql?
Is mysql a free database?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What are mysql queries?
Is sql and mysql same?
What is the full form of mysql?
What is mysqlcheck do?
What are the mysql database files stored in system ?
What is mysqli_result?
What is mysql ndb?
