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
- 4476 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 do I create a schema in mysql?
How does mysql encrypt passwords?
How to enable or disable a row of a table using MySQL in struts?
How do I run mysql from command line?
What is a longblob?
Can mysql store files?
Where does mysql store data?
What is deterministic in mysql?
How do you insert a table?
What is myisamchk?
How can I remotely connect to mysql database?
Which datatype is used for email in mysql?
What mysql -u john -p command does?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How do you rename a procedure in mysql?
