LOAD DATA INFILE 'data.txt' INTO TABLE table

if we want to load data from a text file into a mysql table,
but the columns in table are 1st: code(int) and 2nd:
city(varchar), but in text file the format is 1st cityname
and then code separeted by delimeters. how to load?

Question Posted / vipul dalwala

2 Answers
5068 Views
I also Faced
E-Mail Answers

Answer Posted / vipul dalwala

LOAD DATA INFILE 'data.txt' INTO TABLE table_name
(city,code);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get data from mysql in php?

901

What is mysql root?

952

How we get sum of column.

1010

How can you increase the performance of mysql select query?

924

Explain the difference between mysql and mysql interfaces in php?

1087

What is meant by mysqli?

901

What is row level locking in access?

890

What is the difference between sql and mysql and oracle?

891

Is mysql a backend?

928

How do you shutdown a mysql database?

1048

Where is mysql data stored?

884

Is mysql a odbc?

922

What is root password?

912

Is sql similar to mysql?

887

Can we write procedure in mysql?

939