Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)
I just update the gcc version and still the same problem : absa# gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs Configured with: ../configure --enable-languages=c++ Thread model: posix gcc version 3.0.1 Any Ideas ? thanks - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Angel Behar [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 11:50 PM Subject: Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41) On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote: Hi !! I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't I'm using latest gnu make version and this is the first time that I have problems compiling mysql so if any of you can help me I'll appreciate. Thanks in advance. Which compiler version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,579,267 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems compiling on FreeBSD 3.3 (mysql-3.23.41)
Hi !! I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't I'm using latest gnu make version and this is the first time that I have problems compiling mysql so if any of you can help me I'll appreciate. Thanks in advance. Angel. Making all in client gmake[2]: Entering directory `/usr/home/abehar/mysql-3.23.41/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..- O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_N ET_RETRY_COUNT=100 -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from mysql.cc:28: ../include/global.h:646: warning: abstract declarator used as declaration gmake[2]: *** [mysql.o] Error 1 gmake[2]: Leaving directory `/usr/home/abehar/mysql-3.23.41/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/home/abehar/mysql-3.23.41' gmake: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUP BY problem.
Hi !!! I'm running 3.23.28-gamma under windows NT, but I have the following problem. I need to query some data and gruop by some field (codigo in this case) so I run the following query : SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND activo = 'A' AND p_credito 0 GROUP BY codigo; ++ | codigo | ++ | 319066 | ++ 1 row in set (0.43 sec) the results are as I expected BUT I need to GROUP BY RAND() too and LIMIT to 10 rows : SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND activo = 'A' AND p_credito 0 GROUP BY codigo, RAND() LIMIT 10; ++ | codigo | ++ | 319066 | | 319066 | | 319066 | ++ 3 rows in set (0.30 sec) Actually I try switching codigo, RAND() or viceversa but doesn't work either. As you can see once I use the RAND() option doesn't group codigo, I need this because most of the articles are more than 10 but I really need to solve this problem. Hope anybody can help me. Thanks in advance. Angel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php