Mysql Load data for existing table column

Question

Mysql Load data for existing table column

Initially, I booted. Using Downloadable Data String Infile Has Like 100000 Im Using Ubuntu

Example: data

ToneCode .... Artist ... MovieName ... Language

1 .................... Mj .......... Null ........... English

3 .................... AB .......... Null ........... English

4 .................... CD ......... Null ........... English

5 .................... EF .......... Null ........... English

But now I need to update Column MovieName Starting from ToneCode 1 to 100000 line Im having data in CSV file for updating. Please suggest downloading a .Csv file for an existing data table

+5

mysql ubuntu load-data-infile

vishu Mar 21 '13 at 10:48

source share

2 answers

CBroe · Answer 1 · 2013-03-21T14:11:18+0000

, , MySQL , :

CREATE , ToneCode MovieName, .
CSV, LOAD DATA INFILE
INNER JOIN, http://dev.mysql.com/doc/refman/5.1/en/update.html :
UPDATE items,month SET items.price=month.price WHERE items.id=month.id;
"" items month ( "-" INNER JOIN), id items.price month.price.

vishu · Answer 2 · 2013-03-22T06:08:53+0000

, Guys

Soln:

A (Id int primary Key, Name Varchar (20), Varchar (20), Varchar (20)),

100000,

infile '/Path/file.csv' tablename (A) , ',', '' ' , '\n' (Id, Name, Artist) null

TA (Id int primary Key, MovieName Varchar (20));

TA infile '/Path/file.csv' tablename (A) , ',', '' ' , '\n' (IDx, MovieName)

, join as u said

(TA), (A) A.MovieName = TA.MovieName A.Id = TA.Id

Mysql Load data for existing table column

More articles: