How to load data from a text file into a table?

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / pranab

7 Answers
15365 Views
Sasaa, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to load data from a text file into a table?..

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

How to load data from a text file into a table?..

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

How to load data from a text file into a table?..

Answer / vel

u can import CSV(comma separated value) as a text file.

Is This Answer Correct ?

5 Yes

1 No

How to load data from a text file into a table?..

Answer / sathya

bcp mydb.dbo.sales in sales.csv /U /P /Ssales_fs /c /t,

Is This Answer Correct ?

3 Yes

0 No

How to load data from a text file into a table?..

Answer / sd

Use BCP utilty

Is This Answer Correct ?

3 Yes

1 No

How to load data from a text file into a table?..

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

How to load data from a text file into a table?..

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

Post New Answer