How to load data from a text file into a table?
Answers were Sorted based on User's Feedback
Answer / palanisamy
we have the mysql query which will load csv file into db
syntax:
load data infile 'pathtothefile' into table name
line termineted by '\n',
field teminated by ',';
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / tushar
To load the text file pet.txt into the pet table, use this statement:
mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / vel
u can import CSV(comma separated value) as a text file.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sathya
bcp mydb.dbo.sales in sales.csv /U /P /Ssales_fs /c /t,
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / ramesh
We can load the data to the table in 3 ways.
One is by using controle file
Second one is command Prompt And
Third one is by using apps concurrent program.
1)Load data
infile *
fields terminated by ','
insert into table table name
(
col1 datatype1
)
Is This Answer Correct ? | 1 Yes | 0 No |
What is orm in mysql?
How do I start mysql manually?
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .
What is mysql command line?
How set mysql root password?
How do I find the size of a mysql database?
What is strict mode in mysql?
How do you control the max size of a HEAP table?
what is cte? : Mysql dba
What is the difference Delete and Drop ?
How to control the max size of a heap table?
How do I view tables in mysql workbench?