Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5160 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 can we run batch mode in mysql?
How many columns can a table have?
How do I copy a table in mysql?
How to declare variable in mysql trigger?
How to delete a table.
How do I select a database in mysql workbench?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
What is use command in mysql?
How many threads can mysql handle?
How do I quit mysql?
What is the difference between MyISAM Static and MyISAM Dynamic?
How to delete a database from mysql server.
What is the difference between mysql and oracle?
What is the use of count function in mysql?
What is InnoDB?
