How to load data from a text file into a table?
- 7 Answers
- 14399 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 a blob datatype?
What is the difference between myisam dynamic and myisam static in mysql?
Can you rename a database in mysql?
What are the technical features of MySQL?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How would concatenate strings in mysql?
How many concurrent queries can mysql handle?
Which is better mysql or microsoft sql?
How do I edit a database in mysql workbench?
How to get current MySQL version?
Is mysql a odbc?
What is mysql aggregate functions? Explain
How to extract a unit value from a date and time?
What is blob storage?
Which is best pdo or mysqli?
