Hi Shawn-
This worked great. Perfect. Thanks very
much for your help. If I can ever be of help, let me know - I owe you
one. And thanks Michael and Roger for your help too.
Best regards,
Rick
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 2:14
PMTo:
On Fri, 03 Dec 2004 10:58:30 -0700, Steve Grosz wrote:
I wrote my query as
select Cust_ID, Cust_Name
from mailings
where ucase(Name) = ucase(Cust_Name)
When it runs, I get a error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was clicked on with the Ads ID, and 'Views' is a
simple list of views that ad got, with the Ads ID.
I am trying to SELECT a list of all the ads, with a count for clicks
and a count for views, but my LEFT
At 15:07 +0900 12/4/04, Batara Kesuma wrote:
I can grant another previleges, but not replication slave and
replication clients. How do I fix this? Thank you in advance.
I checked my mysql.user table, and I just found out that it didn't have
Repl_slave_priv and Repl_client_priv columns. How is
Hi,
I'm having trouble converting to and from strings that represent
unsigned BIGINT's.
My server is MySQL 4.1.7-standard and
the following selects were entered at the prompt of my client with
version mysql Ver 14.7 Distrib 4.1.7, for pc-linux (i686).
select cast(1-2, unsigned);
gives the
Depending on how your application works you might be able to batch the
daily updates. Example only do an update every 20 items instead of for
each one. Alternatly you could run an update with a join every 10
minutes or so that would update the daily counter.
On Thu, 2 Dec 2004 20:56:45 -0700,
Ah, I see what you're saying. Each event as it happened might be a simple
insert into a temporary table and then I could batch the total daily
activity into a daily record at the end of the day. A classic size vs.
speed tradeoff.
I was just hoping there might be a (My)SQL way to say update