Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data from a text file into a table?
- 7 Answers
- 15605 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 return type of mysqli_query?
What is mysql good for?
How do I clear a mysql database?
What are the difference between and myisam and innodb?
What is InnoDB?
What is mysqli_free_result?
How does mysql store dates?
How do I edit a table in mysql workbench?
What are the 3 main types of search queries?
How do I get a list of table names in mysql?
How would concatenate strings in mysql?
what is constraints?
Why do we use preparedstatement?
What is acid in mysql?
Is mysql and sql are same?
