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
- 4938 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
Consider you have the following three tables which have to be linked together.
What is a longblob?
What is a text delimiter?
How to present a past time in hours, minutes and seconds?
How do you create a table in mysql workbench?
What is mysql architecture?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is the difference between BLOB AND TEXT?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
How to display top 10 rows in mysql?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
What is mysql url?
What are the different data types in mysql?
How do I create a new database in mysql?
What are mysql functions?
