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 happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?
how many fields can be updated using set in a mysql query?
How do I find mysql location?
How to enter microseconds in sql statements?
What is the datatype for password in mysql?
How to insert dynamic values in mysql using php?
How do I stop a mysql command?
Can varchar be primary key?
How do I create a new database in mysql?
Why do gaps in sequences occur?
How do I select a database in mysql?
Is mysql written in c?