If surname is a field, then use it without the single quotes ('),
otherwise it is treated as a literal string and 0 is the correct result:
select locate(' ',surname,1) from advisers
andy thomas wrote:
Yes, this is the approach I was thinking of using but:
select locate('
for the index files
What is the rule of thumb to use?
Thanks
Vadim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to find documentation on how to setup MySQL cluster
Any ideas?
Vadim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
well, it seems to be fine without SUM and GROUP BY...
E.g.,
SELECT @a:=Charge, @b:=Cost, @[EMAIL PROTECTED] as Margin ...
produces expected results.
Emmett Bishop wrote:
Vadim,
if I'm not mistaken, you can't set a variable then use
it in the same statement.
See http://dev.mysql.com
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql SELECT
- LEFT(CallTime,10) AS CallDate,
- @a := SUM(Charge),
- @b := SUM(Cost
Sorry, the message got garbled, here is a more digestible look:
-Original Message-
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql SELECT
- LEFT
Start another Mysql shell session; then do show processlist; identify
the thread ID of the offending process, then do kill ID. Not sure
how graceful this method is, though. I use it to kill overlooked hanging
connections from time to time.
Cheers,
Vadim.
Scott Haneda wrote:
Every now
improves SELECT .. ORDER BY .. ASC, but
slows down SELECT.. ORDER BY .. DESC at least by a factor of 10. If this
is not a bug, what is it?
Vadim P. wrote:
Hi all,
Sorry to be so persistent, but I am bringing this up again since noone
from the MySQL development
)
===
Thanks in advance!
Vadim.
mysql
query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
The timing is consistent both ways - have tried both queries back-to-back
alternatively many times. I'm pretty sure that it is not caching that causes the
discrepancy.
So, this turns out to be a known issue after all... Somehow I missed it. Thanks, Donny!
Vadim.
- Original Message
have a new
portion of data to be uploaded, first you have to start Perl, then have
it load the script, then establish a new connection to the DB server -
all these steps are totally redundant, but they do overload your box.
Hope this helps.
Vadim.
Chris wrote:
Hi Guys,
Iv got a script that iv
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
://www.sqlmanager.net
Best regards,
Vadim Vinokur
EMS HiTech
http://www.ems-hitech.com
- Original Message -
From: Maciej Bobrowski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 4:27 PM
Subject: InterBase vs. Mysql
Hi,
I am a MySQL admin. I like it very much. It is very
The EMS HiTech company is very glad to inform you that today we uploaded the
MySQL Manager User's guide. It's a 58 page PDF document with pictures
contained detailed information about all the MySQL Manager features.
You can download this file from
http://www.mysqlmanager.com/download.phtml
The
|
| 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
search features) -
without any known issues... That's why I got somewhat too comfortable
using v2.96...
Regards,
Vadim.
crashke wrote:
Hi Vadim, I don't know but have you read the instructions on the
Mysql-website?
To determine if you should be concerned about this compiler issue, execute
The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots
of errors. Had been able to build from the same source w/o any problems up
until a few days ago, when I 'bk resync'ed the source. Any ideas?
Thanks for your help!
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
someone confirm, please?
On a general note, it would be nice to have the formal syntax of FT search
patterns in the manual.
TIA,
Vadim.
[sql query - to satisfy the darn spam filter]
-
Before posting, please check:
http
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
)' in boolean mode);
1979 rows in set (2.53 sec)
--
select tdate, left(header,125) from archivel where match (header) against
('-(president bush) +(donald rumsfeld)' in boolean mode);
== 1535 rows in set (2.45 sec)
--
Thanks,
Vadim.
Sergei Golubchik wrote:
Hi
and t2.col2 is NULL
This syntax does not work in MySQL.
#
I need help!
#
Thank you very much for you time.
Vadim Kulikov
877-428-3279
[EMAIL PROTECTED]
P.S. Someone left a comment with the example on how you can do delete
with join under MYSQL help site. But its
much for your time.
Vadim Kulikov
877-428-3279
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
and t2.col2 is NULL
This syntax does not work in MySQL.
#
I need help!
#
Thank you very much for you time.
Vadim Kulikov
877-428-3279
[EMAIL PROTECTED]
P.S. Someone left a comment with the example on how you can do delete
with join under MYSQL help site. But its
-Original Message-
From: Vadim [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 27, 2002 4:49 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: I need an example on DELETE /UPDATE with JOIN syntax
Greetings:
My company migrated to MySQL a few months ago from Sybase
MySQL Manager,
http://www.mysqlmanager.com/
A lot of features including Export/Import Data,
Visual Query Builder, Extract/Print Metadata,
Syntax HighLight, BLOB Editor and so on.
HTH,
Vadim
- Original Message -
From: John Mayson [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent
Powerful MySQL Manager for Win32.
http://www.mysqlmanager.com
Regards,
Vadim
- Original Message -
From: Joe Fan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 31, 2001 9:44 AM
Subject: GUI for MySql
What GUIs exist for MySql and which is the best to use
Just a thought - if your serial numbers have fixed format, then
programmatically remove the hyphen and store the number without it. Add it
back when displaying data on the screen. That way FULLTEXT will work on the
whole number without splitting it into two parts.
Vadim.
Marty McCoy wrote
Jose--
Are you running mysqld as 'root'?
Run it as 'mysql' and change the group membership of the data directory and
its contents to 'mysql'.
Vadim.
Jose de Leon wrote:
Here are the perms on the mysql db files /var/lib/mysql/mysql
Also, I was logged into mysql with a plain user 'jose
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
I have this query built from a web form. The form
be
FULLTEXT(specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour).
Vadim.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Patrick--
yes, it might take hours, nothing wrong with your setup.
Vadim.
Patrick Goetz wrote:
I recently installed MySQL 2.23.37 from the unstable Debian package on a
dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2
For fun (since I've never tried running any of the benchmarks
of the tables,
for the 6th straight day now.
I'm getting desperate.
What's the completion state of v.4.0?
Will it also improve query performance on big tables?
Thanks,
Vadim.
Sergei Golubchik wrote:
Hi!
On Apr 19, Braxton Robbason wrote:
Hi all,
I'm creating a fulltext index on a 400MB
Erik,
You mentioned 40Gig files on Intel platform -
what OS/DBMS did you use then? How about the performance?
Thanks,
Vadim.
Terry Katz wrote:
Erik,
If your running Linux on an Intel machine (which I assume it is), then
you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want
38 matches
Mail list logo