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
- 5162 Views
- I also Faced
- E-Mail Answers
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
Is mysql a programming language?
what is database black box testing? : Mysql dba
How can you take the backup and restore a mysql database using php?
What is the use of mysqli_num_rows?
What are the differences between char and nchar?
What is a left join mysql?
Is mysqli deprecated?
How do you flush privileges?
What are the 5 r's of managing behaviors?
Is oracle better than mysql?
How database are managed?
What is the difference between truncate and delete in mysql?
What is mysql connection limit?
How to get a list of all tables in a database?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
