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
4944 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 are the mysql database files stored in system ?

989

How do you create a new database in mysql?

865

How to delete an existing column in a table?

884

What does mysql flush tables do?

906

Can't connect mysql server on localhost?

997

What is mysql command line?

969

How to return query output in html format?

876

What does mysql flush hosts do?

836

How does select query work?

858

How do I rename a mysql database?

888

How do I install mysql on windows 10?

923

What is a trigger in mysql?

982

How do I disable mysql?

873

How can you change the password of a mysql user?

910

How do I kill a mysql connection?

852