ote:
> thx all, the source data is in text file.
>
>
>
>
> - Original Message -
> From: "h...@tbbs.net"
> To: mysql list
> Cc:
> Sent: Saturday, April 6, 2013 8:02 PM
> Subject: Re: update a row only if any column has changed, in a very large
&
thx all, the source data is in text file.
- Original Message -
From: "h...@tbbs.net"
To: mysql list
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large table
>>>> 2013/04/06 13:56 -0700, Rajee
2013/04/06 13:56 -0700, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or
uch looks like a nail.
-Original Message-
From: Rajeev Prasad [mailto:rp.ne...@yahoo.com]
Sent: Saturday, April 06, 2013 3:57 PM
To: mysql list
Subject: update a row only if any column has changed, in a very large table
hello,
>
>I have a table with around 2,000,000 records (15 column
hello,
>
>I have a table with around 2,000,000 records (15 columns). I have to sync this
>from an outside source once everyday. not all records are changed/removed
>/new-added everyday. so what is the best way to update only those which have
>changed/added/or deleted?
>
>i can use update_or_crea