Re: Source code build bug in 4.0.0 on Linux on Pentium class machines

Aborting. To continue, re-run with 'cd mysql-test ; ./mysql-test-run --force'. It's in the Docs but that message is a tad misleading because it doesn't work directly from the root make. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Query problem

Functions, and Date Calculations. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: column maximum?

' which you can reference at will, and add new columns to as future needs arise. Paul Dubois _MySQL_ at http://www.newriders.com has a good 'relational database design' tutorial chapter. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Inserting Data on top

?? Sure! Try UPDATE. You will (as it says in O'Reilly,) 'change actual data within a table without altering the table itself.' Meaning you won't be adding or deleting any records, simply adjusting existing records. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Basic index questions

? Again, that's the beauty, MySQL will simply use it if it's available and you SELECT the right indexed fields. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: how to make LOCATE other functions case-insensitive?

return that page in the list. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Need to understand mysql mechanisms

. Changed one DIMM and it purrs like a kitten. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: Connection errors and server polling

monitoring' tool and you might find other uses for it. It can page or email you when 'something' does down. http://www.bb4.com Have a :) day! jb ob-filter-words: table sql database -- jim barchuk [EMAIL PROTECTED] - Before posting

Re: Can field names be longer than ONE word?

/paste. Just for fun, try quoting with `backtick.` That's mentioned related to 'special' chars and maybe space is such. Have a :) day! jb ob-filter-words: database sql -- jim barchuk [EMAIL PROTECTED] - Before posting, please

Re:difficulty compiling v4 --without-innodb

bothered to try to figure out how to do that yet. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Newsgroups

and looking for 'Oh goody! A new group to spam!.' Usenet is essentially a wasteland because the ISPs don't care who does what. The only viable groups out there are moderated, and that's close to a full time job for a list with this kind of traffic. /RANT :) Have a :) day! jb -- jim barchuk [EMAIL

difficulty compiling v4 --without-innodb

]: Leaving directory `/usr/local/src/Apachetoolbox-1.5.41/src/mysql-4.0.0-alpha' make: *** [all-recursive-am] Error 2 There is an innobase/ib_config.h.in but no .h. Any clues? Thanks much. Have a :)day! jb ob-filter-words: database table sql -- jim barchuk [EMAIL PROTECTED

Re:difficulty compiling v4 --without-innodb

! jb -- jim barchuk [EMAIL PROTECTED] - 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

Re: Simple problem: Blank search box returns all records

that right. Someone please correct me if not. Have a :) day! jb ob-Filter-words: databast table sql -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Problem with query

or Heisenberg's box or /dev/null or other places that don't really 'exist' in our normal human plane of reference *but* do in fact exist and can be used. Have a :) day! jb ob-filter-words: database table sql -- jim barchuk [EMAIL PROTECTED

Re: Problem with query

Hi Paul! On Sat, 27 Oct 2001, Paul DuBois wrote: At 9:38 -0400 10/27/01, jim barchuk wrote: Hi Carl! Paul DuBois writes: NULL basically means unknown value, so saying WHERE x = NULL cannot work, even if x is NULL. That means where one unknown value = another unknown value

Re: insert statement

Nimda hits -on- you, not from you. (Code Red looks for default.ida.) You're probably OK because those lines said error - file not found. Have a :) day! jb ob-filter: database sql table -- jim barchuk [EMAIL PROTECTED] - Before

Re: Weird Error Inserting

' instead of just the one. :) Or of course that can be done from the command line too but it's easier with a more 'fixed' file line number reference. Have a :) day! jb ob-word-filter: database table sql -- jim barchuk [EMAIL PROTECTED

Re: MySQL problem with Traffic and Updates

a :) day! jb ob-filter-words: table sql database -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: I am getting crazy!!!

if they have a FAQ page with the promise that if they do you'll never have to ask them another question again. LOL! Have a :) day! jb ob-filter-gunk: table database sql -- jim barchuk [EMAIL PROTECTED] - Before posting

Re: Field Naming Standards

gotta go find where it's defined.' Writing code is easy. Today. Troubleshooting an obscure error months later, or modifying things to add a new feature is -work-. :) A little up front efort -will- help further down the line. Have a :) day! -- jim barchuk [EMAIL PROTECTED

Re: MYSQL CLIENT

to talk to a remote database. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: What sites?

on it. :) Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: newbie can't connect error

a :) day! jb -- jim barchuk [EMAIL PROTECTED] - 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

Re: [OT] FAQ and Commercial Announcements

versions of MySQL and related programs. This is a low volume list all MySQL users should subscribe to. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Multiple field separators

incompatibilities. Have a :) day! jb ob-filter-word: table -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Select Insert

? That is copy over its attributes, etc.? http://www.mysql.com/doc/C/R/CREATE_TABLE.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: RedHat 7.1 refuses to open mysqld]

, which you should change anyway. http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: newbie Q : importing with accents

://www.mysql.com/doc/C/h/Character_sets.html ? Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Question of a beginner

? http://www.mysql.com/doc/G/e/Getting_unique_ID.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: using test database

touch the 'mysql' db unless you know -exactly- what you're doing. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Iist number of connections/users

Hello Raj! What is the command to list all the users connected to mysql server? Type mysqladmin with no parameters for command line help and a list of options. The one you need is processlist. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Corruption of MyISAM table when deleting/inserting ~7000 rows

the problem themselves. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: MySQL Update Logging ???

write permission. Jeremy posted simply 'No' but http://www.mysql.com/doc/O/p/Option_files.html says that ~/.my.cnf overrides previous cnf options. The server can override the user at the command line but only trying it can prove whether it works or not. Have a :) day! jb -- jim barchuk [EMAIL

Re: Unable to connect to mysql server from client

://www.mysql.com/doc/A/c/Access_denied.html Scroll about halfway down to see that -exact- error message. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Problem with MySQL 3.23.40 Install..Source Compiled

a script to retain -your- directory structure and preferences. I also use similar techniques to 'convert' from the rpm system to a 'compiled' version of an application because redhat is often several months to a year to 'forever' behind in upgrades. HTH. Have a :) day! jb -- jim barchuk [EMAIL

Re: can't change to run as ...

/safe_mysqld --log' Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Can't delete from very fat table: ERROR 1030: Got error 22 fromtable handler

during that period to find out the the real limit is.) Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: intro mysql book

waste of $40 and hours or reading I ever spent in my life. Nuff said? To be fair, I did learn how to create a database, import some data, log in to the server, and do a few simple queries. But that's it. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED