Re: intersting bug with full text match against

? ft_boolean_default='AND' if i set it to this , how can i explicitly go from AND to OR ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Stump - [EMAIL PROTECTED] http://www.jerum.com Software never has bugs. It just

RE: table copy

REPAIR TABLE tbl_name QUICK; You could try that or check out myismchk (sp?) --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Cassily, Ryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28

RE: Help MySQL Beginner please.

http://www.mysql.com There's a great manual that got me started. I'd also look on WebMonkey for some basic tutorials. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED

RE: Connect via Internet

you'd be nuts to put it on the internet. Versions 4.x and above support SSL. You'd have to check the mysql site for the specifics. Even with SSL support I'd be wary of putting a db server on the internet. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God

RE: FreeBSD + MySQL bottleneck

This may help - I just got this from a friend. http://jeremy.zawodny.com/blog/archives/000203.html --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Matthias Trevarthan [mailto:[EMAIL

RE: redirect mysql output to file

/to/backups/$i.sql echo $i done --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: Mike Doanh Tran [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:51 AM To: [EMAIL PROTECTED] Subject

RE: # of Business Days?

this helps. There may be more elegant ways of getting such a value. This doesn't take into account day A being wednesday. You might be able to do a SELECT COUNT(*) on evaluating your date to it's Day value in ('Mon','Tue','Wed','Thu','Fri') Check the date commands. --Joe -- Joe Stump [EMAIL PROTECTED

RE: From Win2000/IIS to Linux/Apache ?

I would assume the Win version comes with mysqldump - just mysqldump -uuser -ppassword -hhost database. You *might* be able to copy the data directory (someone else should chime in on this). --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins

RE: How to write delete query??

What you have there is a subselect, which are not supported in mysql 3.2x, but I *believe* are supported in 4.0+ (gamma and 4.1alpha). Don't take my word for it and check the docs first. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins

RE: InnoDB / MyISAM

-- Joe Stump [EMAIL PROTECTED] http://www.joestump.net Label makers are proof God wants Sys Admins to be happy. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 11:29 AM To: Joe Stump Subject: Re: InnoDB / MyISAM Your message

MySQL 4.0 + PHP 4

Anyone out there have anything to share as to using PHP4+MySQL4. I've been hearing good things on the MySQL list about v4.0 and I'm thinking of upgrading, since I run a rather small server. Thanks! --Joe ps. PHP list responders please respond directly. I'm not currently subscribed. -- Joe

RE: Perl DBI $sth-fetchrow_hashref() persistence?

the data is actually stored) then you should be able to use it all you want. Maybe one of the many perl monks will know more. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 6:22

RE: subselect workaround help?

R.StudentID='364326' AND R.ClassID=C.ClassID --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Lefevre, Steven [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 8:22 AM To: [EMAIL PROTECTED] Subject: subselect workaround help? Hey folks

RE: column name

'; --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 8:30 AM To: [EMAIL PROTECTED] Subject: column name Hi all, I guess it's a dumb question for you guys, but MySql manual

RE: Using PHP to do a MySql Dump

You could do an SELECT * INTO OUTFILE (the documentation is on mysql's website). --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Using PHP

RE: Can MySQL handle 120 million records?

it doesn't *work* like Oracle, etc. Overall, in my many experiences, it is more than sufficient for web apps. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:09 AM

RE: Can MySQL handle 120 million records?

very well in. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net 1. MySQL hasn't been proven yet in the corporate environment 2. Some of the comments in the mySQL manual... people losing data doing routine stuff like table optimizations, adding keys, etc. If a database is reliable

RE: Sorting Results

ORDER BY field ASC|DESC --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Mike(mickako)Blezien [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:45 AM To: MySQL List Subject: Sorting Results Hello all, Is there away, within the sql

RE: Newbie- Help with query

You need to do a join ... SELECT T.* FROM transport AS T, acl AS A WHERE T.id=A.id AND A.adminId='1' --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: news [mailto:[EMAIL PROTECTED]]On Behalf Of Max Clark Sent: Wednesday, December 11, 2002 10

Re: Want to create mySQL user through phpMyAdmin

/unsubscribe.php -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: backing up mySQL database ?

I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday

problems querying the list

For some reason I can't send messages to the mysql list - any ideas why? I don't even get a bounce message! --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http

NFS Problem

locally it works just fine. Any ideas what is causing this? --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

sql test

This is a test to the sql list. I sent a message concerning MySQL+NFS problems and it didn't go through. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Before posting, please check: http://www.mysql.com

Re: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

The mysql_num_rows() function returns the number of rows returned in your record set, which when limited is 10 (not 100). Thus you will have to do another query. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: SED [EMAIL PROTECTED] To: [EMAIL

hello?

me since I'm not sure if I'm on the list yet. Thanks! --Joe Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU/Linux --Joe Stump - Before posting

Re: How to upgrade MySQL without breaking PHP/Apache?

) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU