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
- 5054 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 many rows can mysql hold?
What is save point in mysql?
why not null is not allowed at table level
What is mysql cursor?
Is mysql a relational database?
How can we find out which auto increment was assigned on Last insert?
Is mysql same as mariadb?
Write a query to create a database and a table?
How to list or view all databases from the mysql server.
What is slow query log in mysql?
What is MySQL?
What are Heap tables?
What is the size of mysql database?
What is a storage engine?
What is the use of mysqli_connect in php?
