I tried reading this and it took much brain power to do for free. I
suggest breaking this down into the simplest possible example you can.
Ideally have an create table statement, and insert with a small amount
of data (as simple as possible), a simple psuedo code query and
example output of what
This e-mail, including any attachments, may be confidential, privileged or
otherwise legally protected. It is intended only for the addressee. If you
received this e-mail in error or from someone who was not authorized to send it
to you,
Rob,
I need the distinct, lowest values that relate to each other,
not necessarily in the same row.
First, the data representation does not appear to represent the problem
adequately. Second, I do not understand what relate to each other, nor
necessarily in the same row means. Third, I do not
Peter.
I did not ask the question. Go back to jail, do not pass go, do not
collect $200.
Craig,
This problem sucks is kinda fun. Take a look at windowing functions.
MySQL does not have them, but that would probable be the right way to
deal with this. For MySQL I think something like the following
Luck for you my vpn appears to be screwed up. Here is a stored proc I
whipped up:
Stored procedure:
DROP PROCEDURE IF EXISTS s;
delimiter //
CREATE PROCEDURE s ()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE odone INT DEFAULT 0;
DECLARE f1,f2
So with skip-name-resolve in my.cnf (and MySQL restarted), it should
be okay to have [EMAIL PROTECTED] in the GRANT table since localhost
resolves without DNS lookup? Or do I need to specify [EMAIL PROTECTED]
Sorry, just need to clarify this bit before changing a few things.
Thanks again.
Wow, I do feel very lucky. I am only at the this is a cursor part.
I sincerely appreciate your help.
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 10:11 AM
To: Weston, Craig (OFT)
Cc: mysql@lists.mysql.com
Subject: Re: Many to
Presently, I'm only using localhost for MySQL database user
privileges, e.g., :
[EMAIL PROTECTED] -- for all privileges on all databases
Do I need to change the above if I add skip-name-resolve to my.cnf?
(Since localhost is, I thought, not really part of DNS but just an
alias for
Hi!
Andrew == Andrew Aksyonoff [EMAIL PROTECTED] writes:
Andrew Hello Sergey,
Andrew Monday, September 15, 2008, 10:41:31 PM, you wrote:
in MySQL but in general case it can't assume any order and will have
to re-sort the sub-select result by outer GROUP BY instead of inner
ORDER BY. If that
from http://dev.mysql.com/doc/refman/5.1/en/connecting.html
On Unix, MySQL programs treat the hostname |localhost| specially, in a
way that is likely different from what you expect compared to other
network-based programs. For connections to |localhost|, MySQL programs
attempt to connect to
Hello Michael,
Tuesday, September 30, 2008, 8:00:36 PM, you wrote:
Andrew However if the specific sorting algorithm is not stable it *might*
MW It's not stable; MySQL is using several different technics to
MW calculate GROUP BY and may thus return the rows in any order within
MW the group by.
Rob,
I tried this on the small test data, a larger data set and it appears to
make my day. I sincerely appreciate your willingness to help me out.
I do have some questions, mostly so I can understand how this works
better:
I was wondering what the lines:
set odone = done;
set done = odone;
Responses inline...
On Tue, Sep 30, 2008 at 9:21 AM, Weston, Craig (OFT)
[EMAIL PROTECTED] wrote:
Rob,
I tried this on the small test data, a larger data set and it appears to
make my day. I sincerely appreciate your willingness to help me out.
I do have some questions, mostly so I can
[EMAIL PROTECTED] (Database System) writes:
There were no any error message on console or in error log.
The symptoms are
1) the binary log file goes to /data/mysql/data/ dir, not as defined in
/data/mysql/log/
2) the binary log files name start with mysql-bin, not as I defined in
my.cnf
Hi All,
On OS X, I have some Obj-C that creates NSTasks to execute some sql
statements.
What do I deploy on the client to make this work for them? I want to
make it park of my package installer, but I dont know what pieces.
Thoughts?
-Jason
--
MySQL General Mailing List
For list
15 matches
Mail list logo