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(' ','sur
http://dev.mysql.com/doc/mysql/en/Variables.html
A little ways down the page...
"The general rule is to never assign and use the same
variable in the same statement."
-- Tripp
--- "Vadim P." <[EMAIL PROTECTED]> wrote:
Sorry, the message got garbled, here is a more
dige
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(CallT
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),
Start another Mysql shell session; then do "show processlist"; identify
the thread ID of the offending process, then do "kill ". 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 and th
adding an index 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 d
Hi all,
Sorry to be so persistent, but I am bringing this up again since noone
from the MySQL development team commented on my previous post, and the
issue seems very serious, to the point I may start looking to switching
away from MySQL, so - please, please, shed some light on this issue!!!
T
h ASC/DESC on an equivalent query I just 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&quo
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
ssage -
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
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
" and match
(header) against ("reagan");
++
| 1988120101 |
| 19990610115359 |
| 2515123714 |
| 1988112201 |
| 1988112201 |
++
5 rows in set (0.08 sec)
Regards,
Vadim P.
Victoria Reznichenko wrote:
>
> Przemyslaw,
> Wednesday,
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,
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:
>
&
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
a 2.96 compiler
>
> greetings
>
> Jurgen Campforts
> Meidoornlaan 2/1
> 2200 Herentals
> 0496/60.25.75
> http://www.scnoorderwijk.be
> http://crashke.no-ip.biz
>
> -Oorspronkelijk bericht-
> Van: Vadim P. [mailto:[EMAIL PROTECTED]]
> Verzonden: don
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
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!
79 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 Golub
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,
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...
Cou
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 'jos
> > I am running MySQL on a RedHat Linux with raid disks. Should I then
> > use --with-raid when installing ?
> No you dont. If you have a the raid setup by other HW or SW you dont need to
> use the --with-raid.
>
Your answer implied that if your box uses H/S RAID setup, you don't need
'--with-
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 for
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
> AND location = '$location' AND related_discipline = '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
> ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
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 benchm
RedHat 7.1 uses kernel 2.4, which *does not* have a file size
limitation of 2Gb.
I have a few tables bigger than 2Gb (3.23.37 / RedHat 7.1)
It takes forever to index them, though...
Vadim.
Dhiin Data - Erik Dhiin wrote:
>
> Hi,
>
> I have a problem, my database has reached Linux Redhat 7.1
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 w
Sergei,
I also have the same problem, but in my case the table size exceeds 2Gb,
average record size being around 50Kb.
I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/
RedHat 7.1 (kernel 2.4).
As I type this message, MySQL is still [fulltext-] indexing one of the t
Excellent post, Neil! I'm with you! (Sorry to be using up the bandwidth
with this "me too" stuff, but couldn't help it :))
Cheers,
Vadim
Neil Davis wrote:
>
> Guys,
>
> Amen. When I was 13 and got my first commodore 64, I decided to teach myself
> BASIC. All I had was the manual. (the MySQL ma
No, it should work just fine 'out of the box' with SMP kernel. Most
likely you have a permission problem. Check permissions of your MySQL
data directories.
I have a dual P866 Dell Poweredge 2400 / RH Linux 7.0 / MySQL 3.23.29a.
Works just fine.
Cheers,
Vadim.
Lars Freymark wrote:
>
> Hello!
>
32 matches
Mail list logo