Re: intro mysql book

hat this is untested. I seem to recall other minor errors but > > can't find any at a quick glance. No errata has ever been posted to samspublishing.com even though I was told a year ago that it'd ready 'in a few days.'. I will obviously never

Re: Problem with MySQL 3.23.40 Install..Source Compiled

Run mysqladmin -p shutdown. Run that remove.mysql script and blip, your system is clean. Untar the source again and rebuild from a script to retain -your- directory structure and preferences. I also use similar techniques to 'convert' from the rpm system to a 'compiled' versio

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

s in advance. >From rc.local: su - mysql -c '/usr/local/sbin/safe_mysqld --log' & Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the m

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

onna write a cron to log free space 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 (th

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

hout documentation or exact instructions about how to reproduce the problem themselves. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: MySQL Update Logging ???

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 PROTECTED] - Before posting,

Re: Unable to connect to mysql server from client

to change to be able to connect? http://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:

Re: using test database

hurt' anything by fooling around with your own databases. Just don't touch the 'mysql' db unless you know -exactly- what you're doing. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] -

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 PROTEC

Re: newbie Q : importing with accents

abase. Has anyone seen http://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.my

Re: Question of a beginner

(the manual) 8.4.6.3 How Can I Get the Unique ID for the Last Inserted Row? http://www.mysql.com/doc/G/e/Getting_unique_ID.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please chec

Re: Dropping mutliple tables (all tables) from a database_??

wrap here but it's all one command line. mysqldump -p [db] |grep "CREATE TABLE " |sed -e 's/CREATE TABLE //' |sed -e 's/ (//' Or you can do whatever you like, the point is that mysqldump can supply the information you need. The seds just strip off the chars you don&

Re: Select & Insert

> new tables? 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.p

Re: RedHat 7.1 refuses to open mysqld]

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) http://lists.mysql.com/ (t

Re: Multiple field separators

an windows stuff to avoid silly win related formatting 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)

Re: What sites?

om the silicon right up to the UI, but they're working 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.c

Re: newbie can't connect error

Usually works unless there's some more fundamental problem. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: [OT] FAQ and Commercial Announcements

ncement of new 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.

Re: Field Naming Standards

is is to make it it easier to read -later-. A tbl_ is clearly a table and a b_ is clearly a boolean without having to think about it or 'remember' or look it up elsewhere. Such as 'I need to test this variable but is it a boolean or a text, now I gotta go find where it's def

Re: MYSQL CLIENT

ocally 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 archiv

Re: I am getting crazy!!!

ng the -u off, maybe your login name is enough. Only your host admin knows for sure. Ask 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!

Re: Weird Error Inserting

m_id_1, team_id_2) VALUES ( '1', '3', '2', '3') The 'at line' often makes more sense when there're 'more lines' instead of just the one. :) Or of course that can be done from the

Re: MySQL problem with Traffic and Updates

a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that might help. Have a :) day! jb ob-filter-words: table sql database -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.my

Re: Simple problem: Blank search box returns all records

AND (Author LIKE '%varAuthor%')) OR ((Title IS NOT NULL) AND (Title LIKE '%varTitle%')) OR ((Keyword IS NOT NULL) AND (Keyword LIKE '%varKeyword%')); At least without testing I think I got that right. Someone please correct me if not. Have a :) day! jb ob-Filter-words:

Re: Problem with query

ts returned by http://www.mysql.com/doc/manual.php?search_query=null . As described there dealing with NULL requires a 'different' kind of thinking. It's like thinking about black holes or Heisenberg's box or /dev/null or other places that don

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

Re: insert statement

're fine. Those were 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 --

difficulty compiling v4 --without-innodb

c/Apachetoolbox-1.5.41/src/mysql-4.0.0-alpha/sql' make[1]: *** [all-recursive] Error 1 make[1]: 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 :)

Re:difficulty compiling v4 --without-innodb

orked for what I needed it to do. Thanks much. 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 l

Re:difficulty compiling v4 --without-innodb

e very thin, it's a pretty complex app, I'm not a shell-gooroo either, and I haven't bothered to try to figure out how to do that yet. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check:

Re: Newsgroups

r 'spam' and you'll get 470 hits.) But a real, global, newsgroup is just wde open to the folks that have automatic scanners running 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

Re: Connection errors and server polling

;s a dynamite generic 'server 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] ---

Re: Can field names be longer than ONE word?

g the table? Accessing the table? Do't just type in the error, use copy/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 PROTECTE

Re: Need to understand mysql mechanisms

nd memtest86 http://www.teresaudio.com/memtest86/ found bad RAM that -*NO*- other memory tester could confirm. Changed one DIMM and it purrs like a kitten. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, p

Re: Boolean column type?

rting the 0 to No and 1 to Yes. Or you can use ENUM with Y or yes, and N or No. Again, more annoying to write than TINYINT but more human-readable. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please chec

Re: Basic index questions

> How do I tell my client code to "use the index" for sorting? 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]

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

relevant section 3.3.4.7 is -just- off the end of the list when searching for 'like'. A search for 'select' does return that page in the list. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before

Re: Inserting Data on top

ut with a suitable query to achieve the same?? 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

Re: column maximum?

l need to -repeat- that data for -every- record in the database. Better to put that info in the 'judge's table' which you can reference at will, and add new columns to as future needs arise. Paul Dubois _MySQL_ at http://www.newrid

Re: Query problem

ially Date and Time Types, Date and Time 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

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

kefiles that still have pentiumpro in them. ** Suggest: In mysql-test/mysql-test-run.sh, I think $ECHO "Aborting. To continue, re-run with '--force'." should be $ECHO "Aborting. To continue, re-run with 'cd mysql-test ; ./mysql-te

Re: mysqldump & decimals

umber' because it includes the non-number '-' and '.' characters. Perfectly OK with me if the db can deal with things automagically and -I- don't have to muck around with all those lower level conversion details. :) Have a :) day! jb -- jim barchuk [EMAIL PROTECTED]