Which MySQL to install
I've been using MySQL happily on Linux for the past few years; however now I have to develop a web application for a client who insists that I use his server. The server doesn't have MySQL installed, so I naturally want to install it. I'm actually quite lame when it comes to server stuff and I don't really even know which version I should install. When I run uname -a I get: SunOS j-sky 5.6 Generic_105182-21 i86pc i386 i86pc Could someone please advise me on which flavor of MySQL to download? Thanks in advance! - 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-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation prob on i386 solaris 2.6
Database configure problem: When running configure I get the following error: configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. I checked for libm.a and found it in /usr/lib Any idea where I should look to figure this out? Thanks for any advice you can send 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Support for double-byte characters & retrieving
I use mysql with japanese -sjis text (i think it also handles -euc and perhaps others, including Korean) with no problem for inserting and searching. However, to have it sort it the Japanese or Korean way, you should take a look at the following 2 references: http://www.mysql.com/doc/C/h/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 it? I am writing in > Java using JDBC to a mySQL database. > > Thanks, > Kim Albee > - 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 Question (p2)
Q: I have the following table "grades". ++++ | name | score |id | ++++ | John |10 | 1 | ++++ | John | 20 |2 | ++++ | John | 8 |3 | ++++ | Carl |10 |4 | ++++ | Carl |15 |5 | ++++ | Mary |6 |6 | ++++ I'd like to select a single name, maximum score, as well as the corresponding id number and put them in order from highest to lowest and end up with: ++++ | name | score |id | ++++ | John |20 | 2 | ++++ | Carl |15 |5 | ++++ | Mary |6 |6 | ++++ I tried using: SELECT name, id, max(score) FROM grades GROUP BY name ORDER BY score DESC At first I was pretty happy with this, but I realized that although the name and score where the values I was looking for, the id didn't always correspond to the record I wanted. Any ideas - 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
Distinct Selects...
Q: I have the following table "grades": +++ | name | score | +++ | John |10 | +++ | John | 8 | +++ | Carl |10 | +++ | Mary |6 | +++ I want to select distinct names (no duplicates) with a score (for my purposes any score will do for a given name, i.e. John 10, or John 8 would be fine but not both). So I want a result to be something like: +++ | John | 8 | +++ | Carl |10 | +++ | Mary |6 | +++ At first I tried "SELECT distinct name, score FROM grades"; however, this returns all rows as John 10 and John 8 ROWS are still distinct. Any ideas how to get distinct names for this select? - 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
Upgrading RPM 3.23.33 to 3.23.34
Sorry for the basic-ness of my questions, but... What's the best way to upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll have to rebuild PHP or Apache after the upgrade? I'd appreciate any advice from the MySQL sages... - 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