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?
Answer Posted / vipul dalwala
LOAD DATA INFILE 'data.txt' INTO TABLE table_name
(city,code);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is tee command in mysql?
Can we store images in mysql database?
Why is mysql popular?
Is sql similar to mysql?
What is processlist in mysql?
What is information_schema in mysql?
What is maximum table size in mysql?
How many columns is too many mysql?
What is mysql enterprise edition?
What are the types of index?
Where does mysql store data?
What are the different data types in mysql?
What is 'mysqlcheck'?
How can you make a database as your current database?
What is a blob datatype?