RE: Error code 28: No space left on device

the "tmpdir" setting in my.cnf. e.g.: tmpdir = /usr/tmp/ Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

RE: Alter table and add cell at a time.

have to keep track of the row ID (which would be the primary key in this example). Nice to see quiz software being built by an .EDU! Ron Jamison -Original Message- From: Jule [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: Alter table and ad

Joining same table twice for different rows -- possible?

Forgive me if I've missed something in the manual pages; I've always had to do two SELECTs and thus have been looking for a quick[er] solution to this for some time now. Thank you in advance! Ron Jamison (moderators: although I've looked at the manual page plenty of times before,

MySQL EV56 binary?

ha.html), using Compaq's compilers, but as those instructions are optimized for the EV6 I am left thinking there are better/different optimizations for the EV56. Thanks in advance! Ron Jamison - Before posting, p

RE: SELECT frmo two tables

If you need to do a join: http://www.mysql.com/doc/J/O/JOIN.html However I don't see much logic in what you're doing. Stats should not include information that exists in another table, such as name and team. You need to decide what information will be unique (such as player number) or come up

RE: MYSQL on a Cobalt RaQ4

I have a Raq4 running with MySQL + php no problem. Save yourself a great deal of time by loading the packages available from: http://pkgmaster.com/ These Cobalt support team guys maintain security update and misc. packages which, for the Raq 3 and above, happen to include PHP and MySQL. I hig

RE: Trapping for no user input in a query

Kim, See the Pattern Matching section of the manual at: http://www.mysql.com/doc/P/a/Pattern_matching.html A "_" matches any single character, while a "%" acts as a wildcard match. -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 2:36 AM To:

RE: Trapping for no user input in a query

Tailor your query to the request of your user(s). I.e. if only one parameter was passed from the form only match against one field. E.g.: $sql = "SELECT ID, publication,run_date,left(ad_copy,40) as Advertisement FROM classifieds WHERE MATCH "; if ($param1) $sql .= "(ad_copy) against ('

RE: Impact of Free ORACLE

To answer your question I don't think the fabled price slash of Oracle will have any impact on MySQL or its community. Surely you can understand that since this is a mailing list, any posts of such titillating rumors will get a large response. I'd also like to add that after having used MySQL fo

RE: Thanks to whomever... for the tip on mySQLMan...

I agree; theres no reason to use anything but phpMyAdmin for database maintenance over the web. The guys at phpwizard.net keep adding more and more features which strengthen its position as THE package to use for this application. I wouldn't use anything else. $0.02 -Original Message-

RE: Post installation problems in MySQL

Or simply create a symbolic link as suggested in the documentation: ln -s /usr/local/mysql-3.23.49a-pc-linux-gnu-i686 /usr/local/mysql cd /usr/local/mysql ./bin/safe_mysqld & -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:46 AM To: [EM

RE: datafile.MYI has been destroyed & can't recover

c/T/a/Table_maintenance.html as it has saved my own data numerous times. Good luck, Ron Jamison -Original Message- From: Andy Woolley [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 2:44 AM To: [EMAIL PROTECTED] Subject: datafile.MYI has been destroyed & can't recover Hi, I&#

RE: [PHP] Performance

When working with normal connections i.e. non-persistent months ago, using what must've been PHP 4.0.1 or .2, I had some similar experiences. In a number of my more lengthy scripts I was seeing MySQL connections closing on me before the script was done executing. Thus PHP would spit out errors a

RE: Count occurrence of word in a column

I don't think theres a MySQL function to return the number of times a phrase appears inside a field. Another way you could achieve the same goal: SELECT field FROM table WHERE field LIKE '%word%word%word%' ^-- would match on three occurences of 'word' If you need a count of the number of times

RE: [PHP] Performance

I'm fairly sure there's no difference in performance when using PHP tags mixed with HTML blocks as you are doing. Think of it as PHP knowing that it should send everything not in tags directly to the browser. Like an echo or a print, but without needing to specify calls to those functions.

RE: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

nux binary distribution: Core dumped on AlphaServer 1200 Robert Alexander <[EMAIL PROTECTED]> writes: > >Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > >> Ron Jamison writes: > >> > Using MySQL 3.23.46 from: > >> > > >> &g

RE: SELECT'ing only 1st matching row

Tack on a "LIMIT 1" on the end of your query to limit the returned rows to 1. Reference: http://www.mysql.com/doc/S/E/SELECT.html -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:47 PM To: MySQL (E-mail) Subject: SELECT'ing only 1st

RE: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

? What steps did the MySQL team take to get sql-bench running on the alpha EV6 machine? I'd prefer to continue using sql-bench as its easier imho than installing a 3rd party benchmark app. Thanks, Ron Jamison -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

of the week no matter what compile flags you used ;). Any and all suggestions are welcome. Thanks in advance! Ron Jamison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co