On 7/19/08, Rob Wultsch [EMAIL PROTECTED] wrote:
On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy [EMAIL PROTECTED] wrote:
I may be wrong, but I think you could accomplish this through the use of
triggers. Triggers are designed to monitor data change activity.
-jp
Good thought. Using
The next issue of MySQL Magazine is now available for download. Get it
while it is hot! At forty-two great pages it is our biggest and best
issue yet. This issue is anchored by the first annual MySQL Usage
Survey results.
Downloads at the MySQL Magazine homepage: http://www.mysqlzine.net
Thanks
Hello,
I've installed MySQL server 5.0 and have written a small statistics
script that regularly checks the number of connections and queries to
the server, which I can then view in a diagram. But sometimes it just
says that at a time, unusually many connections or queries have been
made to
On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen
[EMAIL PROTECTED] wrote:
Hello,
I've installed MySQL server 5.0 and have written a small statistics script
that regularly checks the number of connections and queries to the server,
which I can then view in a diagram. But sometimes it just says
Hi Mike,
I don't understand with the delete the 'deleted' rows. Can you explain
me more? And about the RAM, yes we are going to upgrade it. The
application opens 1000 simultan connections to service the requests
For the tables, we have 2 identical tables, the flow will be like this.
First when
On Sat, Jul 19, 2008 at 4:18 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
I'm sure there is a way to write this in a single query, but I bet it
it is ugly as heck, probably with a bunch of derived tables.
INSERT INTO balances
On Sun, Jul 20, 2008 at 12:12 AM, mos [EMAIL PROTECTED] wrote:
Is there a way to get Insert ... select ... On Duplicate Update to update
the row with the duplicate key?
That's what it does.
Why can't it do this?
What makes you think it can't?
- Perrin
--
MySQL General Mailing List
For