Hello all,
Seems like I'm not alone:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:52006
On the bright side, I found an answer that pointed me somewhat in the right
direction:
http://www.geocrawler.com/archives/3/13/1998/11/0/56625
I have discovered that I can create a trimmed-down version
Hello!
I have some problems with fulltext search in boolean mode using mysql
4.0.6.
I try to use this query:
mysql SELECT * FROM molotok_lots WHERE MATCH (lot_name,lot_desc)
mysql AGAINST ('+some +text' IN BOOLEAN MODE);
I got error :
ERROR 1064: You have an error in your SQL syntax near
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
[I couldn't find your public key... Is it on a keyserver?]
...and then Benjamin Pflugmann said...
%
% Hello.
Hi!
%
% On Fri 2002-12-27 at 20:15:22 -0500, [EMAIL PROTECTED] wrote:
% [...]
...
% Soo... When you
- Original Message -
From: Chris Faust [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 27, 2002 10:22 PM
Subject: Desperate - failed: Lost connection to MySQL server during query
The problem is this, everytime the web server starts to work a little
(load via a uptime
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
...and then Benjamin Pflugmann said...
%
% Hi.
Hi again!
%
% On Fri 2002-12-27 at 20:37:58 -0500, [EMAIL PROTECTED] wrote:
% Hi, all --
%
% What's the best way to change your database schema around if you have
% data in
can i create reports using
seagate crystal reports with
mySQL as backend.
regards,
gj
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
--- Paul DuBois [EMAIL PROTECTED] wrote:
At 18:38 -0800 12/27/02, Arun Kumar wrote:
Dear All,
I have a table 'X', I want to display the record
in this table 'X' which
Hello Mark,
Thanks for the reply..
I would need to wait until load gets up there to see the state of apache but
even now with almost no load on the machine I'm seeing at least a dozen
connections in the TIME_WAIT state. On the flip site of things I have not
been seeing any other connection
Chris:
I bet a dollar to a donut that you have a hardware problem. The
essential proof is in the first quoted paragraph below. Believe
your data, save your hair.
Regards,
Doug
Filter That! SQL MySQL Query
On Sat, 28 Dec 2002 07:18:07 -0500, Chris Faust wrote:
One other test I did was put
Wow, I don't know if that's a good bet as doesn't a donut cost around a
dollar these days :).
Seriously, It very well could be something hardware related but everything
is brand-new and I'm not seeing any issues logged anyplace with anything on
the machine (except this specific problem at high
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I have tables for clients, instructors, places (rooms), and classtypes,
and finally a schedule where these come together. I'd like to make sure
that a client isn't being double-scheduled (two classes at once), or an
instructor isn't being
Description: Sorting order in latin1 broken
How-To-Repeat: Enter some strings into database and do select...order by
Submitter-Id: submitter ID
Originator:Hadmut Danisch
MySQL support: none
Synopsis: Sorting order in latin1 broken
Severity: non-critical
Priority: medium
On Saturday 28 December 2002 15:20, [EMAIL PROTECTED] wrote:
When querying text strings from a latin1 database,
a text string starting with german Ü is ordered
between W and Y, but should be treated as U or Ue.
For the correct sorting you need another charset (latin1_de or german1).
Regards
On Saturday 28 December 2002 11:40, Anton Zabannikh wrote:
I have some problems with fulltext search in boolean mode using mysql
4.0.6.
I try to use this query:
mysql SELECT * FROM molotok_lots WHERE MATCH (lot_name,lot_desc)
mysql AGAINST ('+some +text' IN BOOLEAN MODE);
I got error :
On Sunday 22 December 2002 20:16, Salam Baker Shanawa wrote:
Hello Victoria,
Is there any plan to make operators work with phrase searches.
something like: against ('comput* scie*') in boolean mode
Yes, it's still in TODO :)
I have tested 4.0.6-gamma and I can see that the bug is fixed:
If you are running close to the same setup with no problems then I feel a
little better about it not being a issue of pure traffic.
As for the scripts, its a heavy reliance on the database for information -
pretty much the whole site is like a classifieds ads system. Other then the
advance
- Original Message -
From: Chris Faust [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, December 28, 2002 1:18 PM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
I really don't think its any of the scripts either, everything
At 2:40 -0800 12/28/02, Arun Kumar wrote:
But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.
Arun
Of course. My answer remains the same. Perhaps I should
add that what all this means is that you must perform
the calculations on
Hi people,
I have a few questions about whether or not i should upgrade to MySQL
4.0.7-Gamma on my Windows XP system. I am now running MySQL 3.23.54a on
my Laptop. Its used for developing/testing, and the applications needs
to be transported to the final server after completion. Most of the
Yes, I do connect to the DB server over IP - in short this is what I do
within MAIN of all my scripts (and $db is what is used anyplace a DB
connection is needed)
##
# Database Setup
# -
#
my $dbpassfile =
Which is the difference between mid and substring functions in MySQL?
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
At 9:44 +0200 12/28/02, Octavian Rasnita wrote:
Which is the difference between mid and substring functions in MySQL?
None. MID() is actually a synonym for SUBSTRING() in MySQL.
sql, query
-
Before posting, please check:
I am getting the following message when submitting the following:
how-to-repeat:
[root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm
error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD
expected(ba03cefd50c27d9d993ce693457c072d) !=
If you are running close to the same setup with no problems then I feel a
little better about it not being a issue of pure traffic.
Yes, we operate in a very similar way to you. (BTW, we have had very good
results with a PHP based cache facility that simply stores the db driven
pages over a
Does anyone know of a runtime way to disable the stopword list? I'm
doing 'boolean mode' fulltext searches, but not getting any results if
the term is in the compiled-in stopword list. It seems like boolean
mode shouldn't even use the stopwords -- they're more for determining
relevence.
I
just install 3.23.53 for ( Mac OS X 10.2 ) from:
www.entropy.ch/software/macosx/mysql
all went well,
saw prompt mysql
type command: show database, saw test, and mysql database
did a \q (quit)
exit okay,
AND THEN !
try to get back into mysql, no luck
can see mysqld is still running.
how does
David,
Or is there perhaps a RENAME DATABASE command (I saw RENAME TABLE)
in MySQL 4.1, you will find ALTER DATABASE:
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News
-4.1.0
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH
David,
I don't have a good example, but suppose I have a few tables with some
fields each and I realize that I should make a new table with data
from
some columns of some tables. What to do?
Do you want to CREATE TABLE tbl_new SELECT (col1, col2, ...) FROM
tbl_old? Or do I miss something
John,
Has anyone been successful in signing up for the certification exam?
Yes. I took the exam (still beta at that time) November 26, in Berlin,
Germany.
I've entered dates going up to Jume 30,2003 to schedule an exam and
all
I get back is exam not available.
The V.U.E. registration
RE: MySQL SELECT and COUNT or SUM
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If you just reply
At 14:38 -0700 12/28/02, Gloria L. McMillan wrote:
RE: MySQL SELECT and COUNT or SUM
Hi, all!
I think this SELECT command does almost what I need.
SELECT CW03survey.Q6, CW03survey.Q7, CW03survey.Q8
FROM CW03survey
WHERE CW03survey.Q3 = '1'
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:44 PM
To: Gloria L. McMillan; [EMAIL PROTECTED]
Subject: Re: SELECT query
At 14:38 -0700 12/28/02, Gloria L. McMillan wrote:
RE: MySQL SELECT and COUNT or SUM
Hi, all!
Michael,
My guess (and this is *only a guess*) -- for some reason one of the objects
is not being created; maybe the recordset object. I am not sure where you
are getting that error number from (presumably in you browser) as you do not
state it. i suggest that you check your webserver logs if
All,
The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.
JBoss (www.jboss.org) stores datasource definitions in XML files, and so
using seems a bit problematic.
Is there any way that the supported delimiters can be extended to use a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
All,
The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.
I'm curious as to where you get a version # of '0.87'. As far as I know
neither MM.MySQL or Connector/J has had a
Mark,
Version was 3.51.05.
amp; works ok. It now seems that it might be related to me trying to use
the NamedPipeSocketFactory. When I use leave these properties out of the
datasource url everything works ok.
socketFactory=com.mysql.jdbc.NamedPipeSocketFactory
namedPipePath=/mysql/pipe
If
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
Mark,
Version was 3.51.05.
Hmmm, that looks like an ODBC driver version. MySQL Connector/J has two
branches right now 2.0.x and 3.0.x, seeing as how you're using named
pipes, you must be using 3.0.x something.
amp; works
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Description:
Most Linux binaries available from mysql.com are compiled to work with glibc
versions as old as 2.0,
but the latest glibc 2.3.2 shipped by RedHat has apparently dropped support
for 2.0 symbols.
This is what you
Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.
Anyone have any good suggestions? I need to perform searches on acronyms
like php.
Thanks.
At 11:57 29/12/2002 +1100, Greg Matthews wrote:
Hi,
If anyone has managed to get named pipes working under Windows XP with
JBoss, would they be nice enough to forward the URL used?
Only one note here: MySQL by default disables the named pipes.
If you want the named pipes you must use at
Hsiao Ketung Contr 61 CS/SCBN wrote:
Does each version of MySql has binary AND src version for installation ?
yes
I found binary version only.
look again
it's on the bottom of the page
Does the majority of MySql user us the binary version ?
dunno ... but it works, so why bother ?
Benjamin Pflugmann wrote:
Look up mysqldump and mysql in the manual. You want to do something
like this:
targethost$ mysqladmin create new_database
targethost$ mysqldump -h oldhost some_database | mysql new_database
at least if he hasn't used innodb with foreign keys
AFAIK mysqldump is not
I would think that using the fulltext search IN BOOLEAN MODE would return
results of any length, even 3 characters or less, check the bottom of
http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using
boolean mode.
Mike Hillyer
-Original Message-
From: Frank Peavy
You need to use the REGEXP capability instead of Like in a where clause
select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';
Jim
-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject:
in sql use perl regular expression:
select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,2}$';
Jim
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words 3
He wants to execute a FULLTEXT search as opposed to a simple LIKE statement,
so I think REGEXP is out of the question.
Mike Hillyer
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE:
thanks Mike,
I think i'll go climb another learning curve :-)
...
Jim
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:49 PM
To: JamesD; Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words 3 chars in 3.23
He wants to
47 matches
Mail list logo