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
5029 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

What is prepared statement in mysql?

936

How do I insert multiple rows in a table?

873

How do I remove a user from mysql?

966

What is full text indexing in mysql?

932

What is pdo in mysql?

904

What is the default port for mysql and how it can change?

1039

How do I download mysql on my laptop?

860

How to include numeric values in sql statements?

985

Can we save images in mysql database?

873

What are the differences between char and varchar data types?

1069

What is mysql port?

1030

What is relational database in mysql?

905

What is ibdata1?

881

How do I create a mysql database?

899

Explain the storage engines in mysql?

986