RE: Error code 28: No space left on device

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 request this thread, e-mail

Joining same table twice for different rows -- possible?

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, http://www.mysql.com/doc

RE: Alter table and add cell at a time.

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 add cell at a time. Quick

MySQL EV56 binary?

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, please check: http

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

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: 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: 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: 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

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: datafile.MYI has been destroyed can't recover

/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've got a 300 MB

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:

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

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]]On Behalf Of Trond Eivind Glomsrød Sent: Thursday, December 13, 2001 9:39 AM To: [EMAIL

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

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: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our

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: 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

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

MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

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.com/ (the list