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?
Answers were Sorted based on User's Feedback
Answer / vijay singh
LOAD DATA INFILE 'data.txt' INTO TABLE table2
FIELDS TERMINATED BY ',';
|Is This Answer Correct ?||3 Yes||0 No|
Answer / vipul dalwala
LOAD DATA INFILE 'data.txt' INTO TABLE table_name
|Is This Answer Correct ?||0 Yes||0 No|
What is offset limit?
how to Return total number of rows.
What tools available for managing mysql server?
how to delete duplicate rows in sql server 2005?
How does select query work?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
What is the datatype of image?
how many fields can be updated using set in a mysql query?
If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?
Why phpmyadmin is used for mysql?
What are the functions used to encrypt and decrypt the data present in mysql?
How does mysql store data?