How to load data from a text file into a table?
- 7 Answers
- 13391 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
In mysql, what is the default storage engine?
What is difference between mysql_connect and mysql_pconnect?
How to convert numeric values to character strings?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
How many concurrent queries can mysql handle?
What is the difference between unix timestamps and mysql timestamps?
What is a mysql server?
What is pragma autonomous_transaction?
Can mysql store files?
Explain % and _ inside like statement?
Does adding an index lock a table?
How can we encrypt and decrypt a data presented in a table using mysql?
how to add a new column to an existing table?
What is view? How can you create and drop view in mysql?
What is back end and front end?
