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
- 5032 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
Is mysql a dbms?
How to show certain selected rows with the value "pcds".
What is blob in mysql?
What is mysql routine?
How do I restore a mysql database?
What is view in mysql?
What causes mysql too many connections?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
How to see table's field formats or description of table .
Can I use mysql for free?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
How does mysql store data?
What is mysql primary key?
Which is faster mysql or mongodb?
Why is mysql popular?
