Re: update a row only if any column has changed, in a very large table

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, Rajeev Prasad I have a tab

Re: remove me from the mailing

This is what happens when a large conglomerate writes large checks. Everyone goes on the aggressive... I'm KIDDING!@!!@#!@!! N. On 4/6/13, Noel Butler wrote: > On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote: > >> You don't have to be a jackass to him/her. >> > > > He's always a

Re: mysql_tzinfo_to_sql

Am 07.04.2013 03:26, schrieb Joe Kosinski: > I was finally able to load the time zone tables using the following: > sh-3.2# /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql > /usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql > -u root mysql gratul

Re: update a row only if any column has changed, in a very large table

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

Re: remove me from the mailing

On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote: > You don't have to be a jackass to him/her. > He's always a jackass, but, I must say, it is a rare occasion that I agree, and, hte *idiot* who posted all those lines was certainly more of a jackass. > The CAN SPAM act requires that

RE: Update and lock question.

Hi Andrés, Select for update makes sure that no other process can change the data between you selected it for update and then actually changed it and commit it. If you do not use "select for update" then it is possible that some other process can change the data in the mean time between you

RE: update a row only if any column has changed, in a very large table

If'n it were my nickel, here is how I would solve the problem (at a somewhat high level). That is, assuming I had an ETL tool available. 1. Create landing tables for your source data. 2. Load data from the source table(s) to your new landing table(s). 3. Perform lookups from the new landing table

mysql_tzinfo_to_sql

I was finally able to load the time zone tables using the following: sh-3.2# /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | /usr/local/mysql-advanced-5.6.10-osx10.7-x86/bin/mysql -u root mysql My version of Mac OSX 10.8.3 did not have root use

Fwd: mysql_tzinfo_to_sql

I also tried mysql_tzinfo_to_sql /usr/share/zoneinfo > sqlLines with the following Terminal output: Terminal Saved Output 10 Description: Binary data -bash: sqlLines: Permission deniedJoeBegin forwarded message:From: Joe Kosinski Subject: Fwd: mysql_tzinfo_to_sqlDate: A

Fwd: mysql_tzinfo_to_sql

1.I was able to use the use mysql; to change to the mysql database and then I ran the queries which showed that the time zone database is not populated. 2. Then I tried to find the path of mysql_tzinfo_to_sql by running the command which mysql_tzinfo_to_sql with the following results: La

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 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

Re: mysql_tzinfo_to_sql

Am 06.04.2013 12:49, schrieb Reindl Harald: > Am 06.04.2013 03:51, schrieb Joe Kosinski: >> I am logged onto the system as system administrator and should have >> privilege to write to the file no you are on MACOSX on this crippled OS a administrator is not the same as root >> I have tried cd

Re: MySQL on RHEL4

On 2013-04-05, Nitin Mehta wrote: > > However, i'm not sure which case it is because in the downloads, it says > "Platform: Oracle and Redhat 4&5" > Isn't it supposed to work? The downloads section is titled "Oracle and Red Hat 4 and 5", but each individual download is clearly marked as just 5.

Re: mysql_tzinfo_to_sql

Am 06.04.2013 17:46, schrieb Joseph Kosinski: > Thanks for the input. I have noticed when I wanted to remove MySql Server > from my system > there were a lot of steps I had to go through and one was to modify the > config file which > was locked not really - the problem is you are lacking an

Fwd: mysql_tzinfo_to_sql

Thanks for the input. I have noticed when I wanted to remove MySql Server from my system there were a lot of steps I had to go through and one was to modify the config file which was locked. I used show info on the file and changed the permissions on it to read write. Then when I tried to cha

Re: remove me from the mailing

You don't have to be a jackass to him/her. The CAN SPAM act requires that a single link, with no further action on behalf of the recipient, must be provided to unsubscribe. I see no such thing in the footer. The website is terrible to navigate on mobile devices... I don't see how I can unsubsc

Re: remove me from the mailing

Am 06.04.2013 18:18, schrieb attee...@gmail.com: > You don't have to be a jackass to him/her. surely, if someone is a) to stoopid to understand that the thousands of subscribers CAN NOT unsubscribe him b) repeats the same line multiple times like a child it is the sad truth that he is a idiot

Re: mysql_tzinfo_to_sql

> Joseph-Kosinskis-MacBook:bin josephkosinski$ mysql_tzinfo_to_sql > /usr/share/zoneinfo > sqlLines > -bash: sqlLines: Permission denied if you need help post your damned commands UNSTRIPPED and mask only passwords and inline is preferred instead attachments which are wasting others time Am 06.0

Re: Cannot load time zone tables to MySQL

Hello Joe On 4/5/2013 10:25 AM, Joe Kosinski wrote: I have installed the community edition version 5.6 to my MacBook running OSX 10.8.3. I am trying to set up MythTV backend which requires the time zone tables to be loaded for the database I will be using. I have not been able to load the tabl