Hi all,
Just noticed that a simple query that returns only 14 rows is 10X slower
when ORDER .. DESC is used compared to ORDER .. ASC.
The table has about 700,000 records, indexed on the field the table is
being ordered by.
Is this expected behavior?
MySQL 4.0.18 running under OpenBSD 3.4
-
From: Donny Simonton
To: 'Vadim P.' ; [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 9:34 PM
Subject: RE: ORDER DESC vs. ORDER ASC exec time
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my breath, even though they seem to be planning
Chris,
I would consider loading this script only once and establishing a single
connection to the DB server and then making it loop with a time delay
waiting for data to be inserted into the DB - that's pretty much what it
does, right?
The thing is that if you invoke the script every time you
tried. So maybe
something is making DISTINCT + reverse index scan slow even if it's not
packed...
Matt
- Original Message -
From: Vadim P.
Sent: Monday, March 29, 2004 8:15 PM
Subject: ORDER DESC vs. ORDER ASC exec time
Hi all,
Just noticed that a simple query that returns only 14 rows
I wish to learn MySQL on my Linux box [SuSE 8.1]
Can I install MySQL on my hard drive and use it for learning *from* the
hard drive, without having to set up a server/network? This would include
MySQLCC.
In other words, can I run MySQL like Access, strictly as a local database,
for learning
Hi,
I was just wondering what the valid range for ports is for the MySQL server
in a Windows environment. Obviously, the server won't connect to a port
already in use, but I know some programs disallow ports under 1024.
Thanks,
Matt
--
MySQL General Mailing List
For list archives:
I am trying to set up a table from a script that came with some software
Value accounting/CRM and i'm getting a few errors, one of which i
can't seem to figure out/fix.
My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb
tables configured with the following statement in my
Hi Folks
Every now and again one of my slaves try's to connect to its master via its
ip address as opposed to its dns name. This causes a problem because the ip
address does not have credentials on the master, therefore, connection
refused -replication ends -databases out of sync- angry
: `mysqladmin VARIABLES -h hostname -p|grep allowed`
I get:
max_allowed_packet 67107840
The maximum post size in my php.ini file is: 32MB
The maximum uploadable file size is: 32MB
According to http://www.mysql.com/doc/en/Packet_too_large.html
this limit should be raised beyond 16MB with MySQL
reconnecting to master
'[EMAIL PROTECTED]:3336': Error: 'Host '111.111.11.11' is not
allowed to connect to this MySQL server' errno: 1130 retry-time: 60
retries: 86400
(Numbers and letter changed intentionally.)
-Original Message-
From: Mikael Fridh
To: DePhillips, Michael P; [EMAIL
Greetings all, I'm trying to grant a user the file privelege and am
getting error messages. Here's my SQL statement
mysql GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY
'password123';
It gets the following error:
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual
Hi,
Quick question since I can't see to find version information online.
What version was enum first supported under?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
directory `/u/david/mysql-4.0.17/mysys'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/u/david/mysql-4.0.17'
make: *** [all] Error 2
Thanks,
David P. Lurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
directory `/u/david/mysql-4.0.17/mysys'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/u/david/mysql-4.0.17'
make: *** [all] Error 2
Thanks,
David P. Lurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
, FL 33904
- Original Message -
From: P Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:31 AM
Subject: reg C API from MySQL
Yahoo! India Mobile: Download
, FL 33904
- Original Message -
From: P Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:31 AM
Subject: reg C API from MySQL
Yahoo! India Mobile: Download
ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: P Arunachalam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:31 AM
Subject: reg C API from MySQL
in the 'Additional library
path:' field.
Pat...
- Original Message -
From: P Arunachalam [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 6:36 AM
Subject: Bug in mysql.h header file
I was trying to establish
Hi,
But will the search be any faster using Integer or
BigInt column type compared to using Date or DateTime
columnd type.
Regards,
--- Nitin [EMAIL PROTECTED] wrote:
no problems that i see.
- Original Message -
From: p shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
I would like to connect MySQL to COBOL via ODBC, I
have installed MyODBC 2.50 in my localhost and I can
able to create the DSN for the MySQL Database in
remote server.
I am in need of an interface to connect MySQL to
COBOL. Is there any provision already exists with
MySQL? if so can you please
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as Integer instead
of DateTime or Date to store the date as
mmddhhmmss or mmdd?
As I know MYSQL accepts this format. But I am not too
sure about the column type.
What are the pros and cons
HI list
When installing mysql 4.16 on debian linux 2.4.20-20.8smp
I get the following errors...
---snip-
--
031112 16:05:08 mysqld started
031112 16:05:08 InnoDB: Started
031112 16:05:08 Fatal error: Can't open
That did it thanks Pete
I need to my installs earlier in the day ;)
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 4:44 PM
To: DePhillips, Michael P; [EMAIL PROTECTED]
Subject: RE: new install failure
Have you checked permissions
installed mysql on gentoo linux.
[EMAIL PROTECTED] etc # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
[EMAIL PROTECTED] etc # mysqladmin -p version
Enter password:
mysqladmin Ver 8.40 Distrib
Hi List
I'm having trouble start a slave. All seems to be configured well as per
show slave status, I issue a
mysql slave start;
Query OK, 0 rows affected (0.00 sec)
and nothing happens, show slave status sill says slave is not running.
Any insght??
Thanks
mike
--
MySQL General Mailing
When end-user use MySQL with any non-GPL licensed program , he must
buy
commercial MySQL license.
Nope. Only If you distribute Mysql with your non gpled commercial
application. Then you need to get commercial licenses for each copy you
sell.
You can use GPL Mysql with Non GPL program as far
Hi All,
I have some doubts regarding Mysqlbinlog. Does Mysqlbinlog support this
usage?
mysqlbinlog --user=root --host=127.0.0.1 master-bin.001.
I am repeatedly getting errors like master-bin.001 file not found in
Linux . When I give the full path of the master-bin.001 its working.
There is a
I have imported 1000s of records into a table and even spent some time
cleaning up characters which I messed up as I imported them (not the
fault of the DB layer, but the result of bringing things into a text
editor), but now I have the following problem.
I have a whole series of author and
:
You have an error in your SQL syntax near '\'22022002\', \'79\')' at line 1
Some reason, MySQL doesn't like the quotes. single or double.
Is there some switch I can set on this msql server?
phpMyAdmin 2.2.0
MySQL 3.23.56 running on localhost
Thanks
John
- - - - -
John Hung P. Ho, Consultant
I am running RH 2.1 ES, i recently upgraded to 3.23.56-1.72. I am using
mysql as a backend for postfix MTA. I use webmin to add new users to my
database. Today, after upgrading, there was a distinct problem. I
added a user, left a field blank, it was the relocate_to feild, which
unless i put
HI List,
Using version 4.0.15
I'm trying to copy a database. Copy db1 to (new) db2.
So I created db2.
And then tried the following and got the subsequent errors.
# mysqldump --add-drop-table db1 | mysql db2
ERROR 1064 at line 399: You have an error in your SQL syntax near
Hi all,
I'm upgrading a mission critical production server with Solaris 9 and mysql
4.0.13 and was wonder if I should install as 64 bit or 32 bit.
I couldn't find much recent discourse on the subject, perhaps some of you
have some experience, known pit falls, ideas or suggestions
Hi All,
The link below says that online backup functionality will be provided
in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is
Mysql going to extend the functionality of mysqlhotcopy so that it works
for Innodb tables also? or they are going to provide independent online
mail
database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send
the expensive bottles of alcohol for when you help put SCO out of their
misery!
P Srinivasulu wrote:
Hi All,
The link below says that online backup functionality
Hi All,
Has the MBREquals function been implemented in the latest 4.1.1-alpha
build. I am finding problems with that command. It says that problem is
there in sql syntax. If it has been implemented. Can you please help me
in the syntax of the command.
I am finding the same problems with the
Hi All,
I tarred up the data directory from mirror1 data base - slave. Copied the
tarball to mirror2 with the hopes of rebuilding mirror2 - another slave.
Backed up the data directory from mirror2 into old and untarred mirror1
Then I did a diff -r against another mirror and the diff came
To be a bit clearer,
should the MYI index files betweened two slaves of a mirrored database be
different?
I would think they would be identical, right?
Thanks
-Original Message-
From: DePhillips, Michael P
To: [EMAIL PROTECTED]
Sent: 7/16/2003 6:18 PM
Subject: MYI file difference
Hi
Paul DuBois [EMAIL PROTECTED] 7/10/2003 10:22:27 AM
At 2:30 -0600 7/9/03, P Srinivasulu wrote:
When Mysql runs on machine with multiple NIC's. Mysql server takes
the
IP Address that we specify in the configuration file. This IP
Address
may or may not be a primary IP Address of that machine. So
When Mysql runs on machine with multiple NIC's. Mysql server takes the
IP Address that we specify in the configuration file. This IP Address
may or may not be a primary IP Address of that machine. So we specify
secondary IP Address for the Mysql server. It listens in that IP
Address.
When Mysql
Hey Folks
I'm having a tough time finding any information in the available
documentation about this feature. Does anyone out there have a bit of
insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is 'on' - that's
about all I can find.
i have redhat e. v2.1 mysql v. 3.23.54a-3.72, postfix 2.0.10, courier-1.7.3
and amavisd-new (newest version) and i'm successfully running mysql as the
backend for both. My question is this:
all of the data for the above programs is all stored in a bunch of different
tables. aliases_this,
How can one allow a user to change their mysql password securily?
If I do a grant update on the user table, then a user could change anyone's
password. I just want a user to be able to change their password. Is this
possible?
Shawn
--
MySQL General Mailing List
For list archives:
On 3/24/03 10:37 AM, R. Hannes Niedner [EMAIL PROTECTED] wrote:
On 3/24/03 7:41 AM, Shawn P. Garbett [EMAIL PROTECTED] wrote:
How can one allow a user to change their mysql password securily?
If I do a grant update on the user table, then a user could change
anyone's password. I just want
Hello,
I want to know whether the mysql depot (mysql-3.23.54a) works on
HP-UX PA_RISC2.0 or it works only on PA_RISC1.0.
If it doesn't work on PA_RISC2.0, where can I find a mysql depot
that works on PA_RISC2.0?
A quick reply will be greatly appreciated.
Thank You,
Chaitanya Atreya.
Hi,
I've readed the following post :
PROVO, Utah and SEATTLE - Oct. 21, 2002 - Novell and MySQL
AB, developer of the world's most popular
open source database, today announced that Novell will ship
a NetWare-optimized commercial version of the MySQL
database with Novell® NetWare® 6 and
PROTECTED]
cc:(bcc: Murali P/Satyam)
Subject: Different Table type between MASTER and SLAVE
Hello.
I'm build a system aka of Shopping mall.(I think most of queies will be SELECT)
For performance, MySQL will run on replication.
I need TRANSACTIONs to manages orders and payment.
So, Master's
PROTECTED]
cc:(bcc: Murali P/Satyam)
Subject: Different Table type between MASTER and SLAVE
Hello.
I'm build a system aka of Shopping mall.(I think most of queies will be SELECT)
For performance, MySQL will run on replication.
I need TRANSACTIONs to manages orders and payment.
So, Master's
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
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
I tracked down the bug
I have one table with BLOB field in it
Then I execute queries like
SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
here, keywords is a blob fields
when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
hope this helps
--
Paul P
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB?
How can I find these rogue queries and optimise them? I could increase the
I have about 300 database tables that are mostly ISAM and some MyISAM
format. I would like to move them all into MyISAM - what's the
easiest/quickest way? I am running 3.23.54.
I was thinking of doing mysqldump, then using a search/replace in the file
CREATE TABLE .. TYPE=, then recreating the
I want to upgrade my MySQL version (3.23.51) because of the recently
revealed exploit; the only binary dist on mysql.com for solaris 2.7 is
3.23.53; will there be a problem compiling from source on this platform or
should I wait for the binaries to be updated? There is a .54 release for 2.8
and
show databases.
-Original Message-
From: Will Standley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 10:36 AM
To: MySQL List
Subject: How to get MySQL to list current db's ?
I have two sample MySQL db's running on a local Linux box w/Apache...
Once I enter mysql from the
There is no clustering in MySQL. Replication features allow something
similar.
In my opinion, the reason I prefer MySQL is the fact that the basics are
there to do what ever you need to.
You are responsible for making the solution, not the vendor.
Multiple MySQL slave servers, and multiple
show variables
that will show you what you need.
you can use a like statement, because there is a lot of stuff
hope that helps
brian
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 9:51 AM
To: [EMAIL PROTECTED]
Subject: RE: mysql port
Hi,
I´m using MySQL version 4.0.5 in Windows and I want to make a JOIN between
two tables that have approximately 20,000 records and 20 columns. As all
the records
from one of the tables must appear in the result of the SQL( the tables
don´t have the same
number of records) , I ought to use a
Keith C. Ivey wrote:
On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:
When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually
what mysql version is recommended for running w/apache 1.3.26 php
4.2.2?
i'm having trouble getting mysql config'd w/these wonder if i should
avoid/lean to any particular versions?
-
Before posting, please check:
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't set root user passwd? simple syntax
error?
[root@a bin]# ./mysqladmin -u root -p password pp
Enter password: i enter p again
./mysqladmin: connect to server at 'localhost' failed
, or rpm, or binaries. but does
it matter if the php apache are source then the mysql is binary?
It is the other way around.
You configure PHP and apache to use mysql.
Chect the installation documents for PHP and apache
for instructions on how to use MySQL.
P. Fawcett wrote:
what mysql
Hi Wim,
I'm no expert with compilers and mysql either, but I have gotten mysql
to compile sucessfully on Solaris 9 using gcc 2.95.2.
If you look at http://www.mysql.com/downloads/mysql-3.23.html , in the
source code download section, you'll see that they recommend using the
compiler gcc-2.95.2,
This morning our MySQL exited for no good reason!
mysql.err:
021020 17:25:53
021020 17:
021022 18:20:16 mysqld ended
mysql.log:
021022 18:20:09
243748 Connect mysql_user@localhost on
243748 Init DB mydb
243749 Connect [EMAIL PROTECTED] on
243749 Init DB mydb
243748 Quit
243749
JP 021022 18:20:16 mysqld ended
JP 243749 Query INSERT INTO IDRefs
JP VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not
available','','')
MySQL server always crashes on this query? What is the structure of
the table IDRefs?
Not always, just a few times in the last few days
Another error!
PHP starts to output the error Too many references: cannot splice - error
144
When logging into mysql, I get:
Didn't find any fields in table IDRefs
started with -A, I get:
cannot open file: IDRefs.MYD (error: 144)
optimize table IDRefs;
Can't open file: 'IDRefs.MYD'. (errno: 13)
Error 144 that the table is crashed and the last repair failed. You should
run a check and optimize on this table if possible. Error 13 indicates
that
you do not have permission to access the file. If you are the System
Administrator you may want to check the file permissions. Otherwise, you
$ perror 144
144 = Table is crashed and last repair failed
Your table is corrupted, try to repair it with REPAIR TABLE or
myisamchk:
http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives
| mydb.IDRefs | repair | error| Can't create new tempfile:
'./mydb/IDRefs.TMD' |
frustrated trying to sort through the diff recommendations in getting
new server install to work on redhat 7.2, w/ apache 1.3.26, php 4.2.2
source compiled. (ok so i'm new to the free world)
pls correct me if i'm wrong, but i understand don't use rpms (haven't
figured out why not tho), go for
[root@liz root]#
Fix:
None yet
Submitter-Id: Stan P. van de Burgt
Originator:root
Organization:
DMO
MySQL support: none
Synopsis: mysqld hangs when accessed from external interface / servers
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release
So, a fix to this MySQL bug anyone??
- Stan
-
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
--disable-shared was used for
configuration, and was previously successful with 3.23.52.
gcc 2.95.2 and the SCO linker with libraries, along with FSU pthreads
were used for compilation, which ran without error.
Thanks,
David P. Lurie
Rheumatology Associates, P.C.
106 Woodlawn Drive
Johnson City
the error host xyz is not allowed
to connect to this MySQL server rather than hanging.
I uninstalled 4.0.3 and rebuilt/installed 3.23.52 just to make sure that
I hadn't made any system changes, and 3.23.52 (server and client
programs) still runs without error.
David P. Lurie
Rheumatology Associates
thanx 4 your reply:
this is the error message that i got when i tried using the full pathname.
mysql LOAD DATA INFILE /home/ihot/member.txt INTO TABLE member;
ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13)
mysql
i've tried using another user account (of course i've set all
hi all,
i have a problem with load data... statement. i'm using MySQL 3.23.49 from
RedHat 7.3. i read Paul DuBois book about MySQL, and tried to load data to
my member table,
mysql LOAD DATA INFILE member.txt INTO TABLE member;
but i didn't work.
i've tried by removing the 'local', but it
Hi All
I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.
I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems
Hi,
I want to know one thing about MYSQl,
Why does this software always give the unix-socket
problem when compiled and installed.
I am installing on redhat 7.1.
Is there a remedy to this or this will continue
forever.
Any help will be appreciated.
Thanks
Hi,
OK - Here's plain text. I don't know anybody else that uses it, so let's see
if you accept it THIS time!
I have a network made up of two PCs, one is Win98 and the Server is Linux. I
am not using NIS, preferring to use host instead. I can ping each machine
at either end and Samba works just
Hi,
I am looking for help on writing stored procedures for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
Yahoo! -
Hi,
I am looking for help on writing stored procedures
for
Mysql 4.0 and above.
Any examples or pointing to advanced tutorials
covering stored procedures for Mysql will be highly
appreciated.
Thanks in advance.
__
Do You Yahoo!?
MS Access
MS Office Based.
It is has more graphic tools.
Possibly more people will be able to manipulate the database since Access
has very little security, this is not usually an advantage.
Lastly only a few people will be able to use you application before MS
Access fails... Therefore limiting
Hello -
I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on
a DELL Latitude C600 Laptop developing a project. However every time i try
to use mysql_num_rows it tells me that this is not a valid mysql result
resource. I've tried all kinds of differnt tricks to try to fix the
Hi,
Currently I am using | (pipe) (without quotes) to
separate values if they belong to the same user.
eg : If a user wants to receive an e-mail on Friday
and Saturday I will put in the required field 5|6.
And than retrieve that split/explode it with | and
check the value.
Is there any other
Hi,
I want to start the autoincrement field in mysql
primary key from 1000 instead of 1.
Any ideas.
Thank You.
Piyush.
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
I haven't seen a mysql question since friday?
-
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
Hi,
I have a quick question concerning date/time functions. If I query
MySQL:
SELECT date_format(date, '%W %M %e %Y') FROM experiments where
expid=3706
It returns: Wednesday May 2 1979
Are there existing methods for determining whether to add st, nd or
rd after the %e?
e.g. in this
|
| 2515123714 |
| 1988112201 |
| 1988112201 |
++
5 rows in set (0.08 sec)
Regards,
Vadim P.
Victoria Reznichenko wrote:
Przemyslaw,
Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
PP SELECT ISBN,TITLE FROM tBooks
PP WHERE tBooks.ISBN=1876340436
PP AND MATCH
Sergei Golubchik wrote:
rebuild your indexes (the proper way to do it is to issue
REPAIR table_name USE_FRM
Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
TIA,
Vadim.
/* sql, mysql to satisfy the spam police */
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
I am able to reproduce this problem very easily, including on
Redhat-7.2. Basically, any app using the libmysqlclient.so
compiled with gcc-2.96 connecting to a server compiled with
gcc-2.96
Mike,
BTW, have you been able to build Mysql 4.0 under RH7.x from the development
tree lately?
I keep getting some missing definitions messages as of last week, when I
performed a regular 'bk resync'. Prior to that, all had been just fine.
TIA,
Vadim P.
Mike Robinson wrote:
Hello to all
/60.25.75
http://www.scnoorderwijk.be
http://crashke.no-ip.biz
-Oorspronkelijk bericht-
Van: Vadim P. [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 9 mei 2002 23:07
Aan: [EMAIL PROTECTED]
Onderwerp: Re: Help! Error building 4.0.2 under RH Linux 7.2
Just tried building Mysql-3.x.x
checking how to check if pid exists... /bin/ps p $$PID | grep mysqld
/dev/null
checking for kill... (cached) /bin/kill
checking for kill switches... /bin/kill -0 $$PID /dev/null 2 /dev/null
checking for gcc option to accept ANSI C... (cached)
checking if we should use assembler functions
Just tried building Mysql-3.x.x cloned from the Development Tree on the same
machine - works like a charm. Still no luck with 4.0.2
Is there any known issue regarding building 4.0.2 under RedHat7.2?
Thanks,
Vadim.
Vadim P. wrote:
The Dev. Tree Source MySQL 4.0 no longer builds
i got an error msg. that this was not posted... hence i am doing
it once more
Praveen
On Mon, 06 May 2002 p j j wrote :
hi all,
I am using mysql on Win98 platoform. Am facing problems
using the Time field in SQL queries being executed from a VB
program. Would it be possible
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)')
don't produce the result desired, that is, multiple .. elements are not
allowed, with or without parentheses...
Could
Of course, I forgot to mention 'IN BOOLEAN MODE'.
...
MATCH (some_text_field) AGAINST ('(red pepper) (green bean)' IN BOOLEAN
MODE)
...
Vadim P. wrote:
Hi,
It's not quite clear from the manual, but it appears that queries with
FULLTEXT search patterns like this:
MATCH
Sergei, here:
RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2
A snapshot from a live database, sorry, couldn't prepare a more detailed
example:
--
select tdate, left(header,125) from archivel where match (header) against
('donald rumsfeld' in boolean mode);
== 188 rows in set (0.12
hi all,
I am using mysql on Win98 platoform. Am facing problems
using the Time field in SQL queries being executed from a VB
program. Would it be possible for someone to help me out with
this
At mysql prompt
1. CREATE TABLE TEST(field Time) success
2. INSERT INTO TEST(field)
101 - 200 of 287 matches
Mail list logo