SELECT QUERY Problem

2001-12-10 Thread Anatole
| score 15 | 50 15 | 55 15 | 60 15 | 45 What I want to end up with is a selection that would pick up George and his highest score on score_1 and score_2 (i.e. George 95 60) Anybody have a pretty way to do this??? Thanks for any advice you can throw my way! anatole

Myisamchk's Error 22

2001-07-31 Thread Anatole
TiA, Anatole - 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-m

The old interfering with the young

2001-07-26 Thread Anatole
version. Anyone know how I can get rid of the old files and fix my environment so that my new MySQL distribution is called when I enter "mysql", "mysqladmin", and the like on the command line? TIA, Anatole - Be

Remote Connection Strangeness

2001-06-27 Thread Anatole
d what is going on when a remote connection is made. Any clues? If so, please send a CC to my email address. TIA :-] - anatole - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

Re: Need Japanese character set files

2001-06-05 Thread Anatole
acter set 13 (path: default) in /usr/local/apache/sites/gaijinpot.com/php/common.inc Thanks again for your help! Anatole - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: Need Japanese character set files

2001-06-05 Thread Anatole
following question: 1. What do you mean by >More complex character sets must > be compiled into the server. And how would I go about doing this? TIA Anatole - Before posting, please check: http://www.mysql.com/manua

Efficient Query/Database Structure?

2001-05-17 Thread Anatole
amp;34 When searching I'm using: REGEXP '^$search_category$|^$search_category&|&$search_category&|&$search_category$ ' This seems to work fine, however I was wondering if there is a better way...

Installing a source distribution after an rpm installation

2001-05-17 Thread Anatole
"over" the currently installed rpm version, or is it trickier than that? Any input would be great! - anatole - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Repost: Intall problems on i386-pc-solaris2.6 (bug?)

2001-05-16 Thread Anatole
Making another appeal for help Anybody have any clues to what I could do to fix the problem below? > I tried to configure MySQL like this: > > ./configure --prefix=/usr/local/mysql --with-charset=sjis > > After a hundred lines or so of install verifications, it quits the > installation with

Intall problems on i386-pc-solaris2.6 (bug?)

2001-05-15 Thread Anatole
I tried to configure MySQL like this: ./configure --prefix=/usr/local/mysql --with-charset=sjis After a hundred lines or so of install verifications, it quits the installation with the following: checking whether struct tm is in sys/time.h or time.h... time.h checking size of char... 0 configur

Re: Installation prob on i386 solaris 2.6

2001-04-22 Thread Anatole Varin
end my way , Anatole - 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 uns

Re: Support for double-byte characters & retrieving

2001-04-03 Thread Anatole Varin
/Character_sets.html http://www.mysql.com/doc/c/o/configure_options.html - Anatole > I am using mysql to store content that will contain double-byte (korean, > japanese) language text -- What is it that I need to specify when inserting > that type of text (if anything) and how do I retrieve