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?
- 2 Answers
- 4067 Views
- I also Faced
- E-Mail Answers
Answer Posted / vijay singh
LOAD DATA INFILE 'data.txt' INTO TABLE table2
FIELDS TERMINATED BY ',';
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to determine the location of the data directory?
Is mysql a server or database?
Can not connect to mysql server 10060?
What is the use of mysqli_query?
How to check if value already exists in mysql database in php?
How do I completely remove mysql from windows?
What is myisam?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
How do you use auto increment?
What is tee command in mysql?
What are the advantages of mysql?
Does mysql use t sql?
Why mysql is open source?
How many rows we can insert in a mysql table?
What is pragma serially_reusable and why is it used?
