Re: Selecting a group of distinct items?

2005-10-06 Thread Manish Marathe
of course, although DISTINCT(name) works On Fri, 2005-10-07 at 12:29 +1300, Jasper Bryant-Greene wrote: > Manish Marathe wrote: > > SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC; > > DISTINCT is not a function. The above (if it even works) is exactly

Re: Selecting a group of distinct items?

2005-10-06 Thread Manish Marathe
SELECT DISTINCT(name), date, value FROM table_name ORDER BY date DESC; On Thu, 2005-10-06 at 17:33 -0400, Donnie Lynch wrote: > Hi, > > I'm pretty much an SQL newbie, so apologies in advance if this is > basic stuff. That'll teach me for skipping the databases class in > college... > > I just c

Error Running MySQL tests

2005-10-05 Thread Manish Marathe
Hello all, I checked out the MySQL code and was running tests using mysql-test- run.sh. I keep getting this error: ERROR: /tmp/mysql/mysql-test/var/run/master.pid was not created in 400 seconds; Aborting Any insights, suggestions ? Thank You -Manish -- MySQL General Mailing List For list

Re: Running MySQL tests

2005-10-05 Thread Manish Marathe
Hello, Any inputs or information on running MySQL tests under Valgrind, http://valgrind.org . Thanks -Manish On Tue, 2005-10-04 at 14:25 -0700, Manish Marathe wrote: > Hello All, > > I was building mysql after checking out from the bk repository. In that > process, while executing

Running MySQL tests

2005-10-04 Thread Manish Marathe
Hello All, I was building mysql after checking out from the bk repository. In that process, while executing mysql tests I executed them in the environment of Valgrind with the output in xml. After each test case Valgrind thinks output is completed so it completes its xml outputfile, but when the