efault boolean value
?
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.co
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: W
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--
7;s a production box
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
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 Trevartha
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')
do
mysqldump -uroot $i > /path/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: Mo
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 Go
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
--
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 / MyISA
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
subs
e 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
AS R WHERE
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 wo
T 'MI';
--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 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]
Sub
of tasks - it just depends on which task you need
your DB to perform 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
erprise-status because 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: Wed
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, with
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, D
il
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Joe Stump - [EMAIL PROTECTED]
"Software never has bugs. It just develops random features."
-
Before postin
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: <[EMA
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 chec
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.mysq
un the DB files 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://
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 P
type)
mysql> alter table tablename change field field newtype ;
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
- Original Message -
From: "Aaron Merrick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 01, 2002 4:25 PM
Subject:
You can also put this in your mysql_connect ... check out the syntax for it
but I believe you can do this:
mysql_connect("server:port:socket","username","password");
--Joe
On Tue, Jun 12, 2001 at 05:17:58PM -0500, Whit Blauvelt wrote:
> On Mon, Jun 11, 2001 at
ting, 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]>
> To unsubscribe, e-mail &
p and please cc 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
---
29 matches
Mail list logo
