- Original Message -
> From: "Shawn Green"
> Subject: Re: Query optimizer-miss with unqualified expressions, bug or
> feature?
>
> On a more serious note, indexes with limited cardinality are less useful
> than those with excellent cardinality. Cardinali
Hi Shawn,
On 19.10.15 22.33, shawn l.green wrote:
On 10/19/2015 3:48 PM, Roy Lyseng wrote:
Hi Ben,
On 19.10.15 16.07, Ben Clewett wrote:
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and
then use
two starts: one on 'a > 0' and
On 10/19/2015 3:48 PM, Roy Lyseng wrote:
Hi Ben,
On 19.10.15 16.07, Ben Clewett wrote:
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and
then use
two starts: one on 'a > 0' and one on 'a < 0', taking a union of the
result?
Which
Hi Ben,
On 19.10.15 16.07, Ben Clewett wrote:
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and then use
two starts: one on 'a > 0' and one on 'a < 0', taking a union of the result?
Which might make a significant result to something
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and
then use two starts: one on 'a > 0' and one on 'a < 0', taking a union
of the result? Which might make a significant result to something?
Ben.
On 2015-10-19 14:19, Roy Lyseng wr
Hi Ben,
On 19.10.15 15.10, Ben Clewett wrote:
I have noticed that an unqualified boolean expression cannot be optimized by
MySQL to use an index in 5.6.24.
For example:
CREATE TABLE t (
i INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
a BOOLEAN NOT NULL,
KEY a (a)
) ENGINE=InnoDB;
This wi
I have noticed that an unqualified boolean expression cannot be
optimized by MySQL to use an index in 5.6.24.
For example:
CREATE TABLE t (
i INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
a BOOLEAN NOT NULL,
KEY a (a)
) ENGINE=InnoDB;
This will hit key 'a':
SELECT * FROM t WHERE a = TRUE;
IL PROTECTED]>
To: Paul Nowosielski <[EMAIL PROTECTED]>; mysql@lists.mysql.com
Sent: Monday, December 1, 2008 6:42:19 PM
Subject: RE: regular expressions matching only numeric characters in order
Hi
I am a bit of novice at Regexp, but I believe this will work for you
(\d+\d+\d+).*(\d+\
Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.
(333)333-
333-333-
33
So I am wa
cceptable in my case.
So is there a way to use wildcards/regular expressions in IFNULL? Is
there another way to create a view that substitutes every NULL-value
with 0?
I'd appreciate any kind of help very much!
Kind regards and greetings from Munich,
Felix
--
MySQL General Mailing List
For
oblem,
that it doesn't reflect new columns in the original table in the view,
as there is no corresponding IFNULL-command in the view. This is not
acceptable in my case.
So is there a way to use wildcards/regular expressions in IFNULL? Is
there another way to create a view that substitutes every
ents of the address ("123" and
"12345"), they would match.
I am wondering, is there a way to search through a table like this (all
fields are varchar):
fname, lname, address, city, state, zip
Using regular expressions, to show any records which match another record on
lastn
max key value to be inserted in the table instead of
using the auto-increment (because it's rollback-unfriendly). However,
I wonder if using such expressions (I not using any other functions
except SQL Aggregate functions) in the select column-list would slow
down the INSERTs and wha
t; For example:
> Search for hotels where location is "Bern" and the hotel has sparetime
> activity 2 and 5 AND services 5 and 3 and 7
> So only hotels which match all the expressions should appear as results.
>
> I've tried it with the following Query but this
Thank you very much.
Works perfectly now.
-Ursprüngliche Nachricht-
Von: Harald Fuchs [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 15. Juli 2004 13:58
An: [EMAIL PROTECTED]
Betreff: Re: query w multiple tables and expressions
This gives all hotels having at least one of the required
tel has sparetime
> activity 2 and 5 AND services 5 and 3 and 7
> So only hotels which match all the expressions should appear as results.
> I've tried it with the following Query but this doesn't work as it should.
> ***
on is "Bern" and the hotel has sparetime
activity 2 and 5 AND services 5 and 3 and 7
So only hotels which match all the expressions should appear as results.
I've tried it with the following Query but this doesn't work as it should.
*
Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
I'm still new to Mysql so I'm not sure on this but I think the problem
is with your ORDER BY field. Since you
On Mon, 19 Jan 2004, Ian O'Rourke wrote:
> Regarding the following query:
>
> SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
> %y'),SectionID,Title,Summary,Content FROM articles
> ORDER BY EntryDate
> DESC LIMIT 10
>
> Okay, I've looked in the manually up and down, as I know how to do it in
> Acce
rom: "sulewski" <[EMAIL PROTECTED]>
> I think you can just put the alias after the field like so,
>
> select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
> SectionId,Title,Summary...
>
You were correct - the version using AS does not work (I'd tried that before
mailing).
--
MySQL
I think you can just put the alias after the field like so,
select id,author,date_format(entrydate,'%d %m %y') ArticleDate,
SectionId,Title,Summary...
On Monday, January 19, 2004, at 02:16 PM, Ian O'Rourke wrote:
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'
you were so close
http://www.mysql.com/doc/en/SELECT.html
SELECT COLUMNNAME AS WHATEVER FROM TABLENAME;
Marty Gainty
- Original Message -
From: "Ian O'Rourke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:16 PM
Subject: Ex
Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
Okay, I've looked in the manually up and down, as I know how to do it in
Access, but I can't find it. I want to set an expression so I
Sorry about the double posts...
But I forgot something...
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Can something be done so that mysql be case sensitive ?
If you only need case-sentivitity on selects read this:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
" The B
On Friday 28 November 2003 14.51, Lemasson Sylvain wrote:
> Hello,
Hi
> The first think is that I cannot add a primary constraint on test because
> Mysql do not make the difference between 'bla' and 'BLA'. It is case
> insensitive. I have the same problem when I do: select * from test where
> valu
Hello,
I have a simple table test like
create table test (value varchar(10));
in witch I have insert two lines:
insert into test values('bla');
insert into test values('BLA');
The first think is that I cannot add a primary constraint on test because M
audience would be the same plus I saw some other posts
regarding how to construct tables and queries.
> Can SQL statements evaluate expressions? I want to store thousands of
> equations, and return a subset when I plug in a value.
>
> For instance, if I stored the following two equations:
Can SQL statements evaluate expressions? I want to store thousands of
equations, and return a subset when I plug in a value.
For instance, if I stored the following two equations:
x = y + 5;
x = 100 / y;
I might want to query for all records whose x is less than 10 when y is
equal to 3. I&#
Hello,
I¹m trying to filter a column of phone numbers that contains spaces,
parenthesis, dashes, and possibly letters using sql with the following
query. Am I going down the right path with the following sql statement or
should I be doing something totally different? I¹m trying to say use the
cont
;
> It is the same as using the LIKE operator wit more
> complex patterns
>
> Dobromir Velev
> [EMAIL PROTECTED]
> http://www.websitepulse.com
>
>
>
>
> - Original Message -
> From: "Darren Young" <[EMAIL PROTECTED]>
> To: <[E
PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 00:02
Subject: Regular Expressions
> I've looked through the mysql manual for information on regualar
> expressions, and all that it seems to have are references such as:
>
> SELECT "fo\nfo" RE
On 5 Feb 2003, at 16:02, Darren Young wrote:
> I've looked through the mysql manual for information on regualar
> expressions, and all that it seems to have are references such as:
>
> SELECT "fo\nfo" REGEXP "^fo$";
>
> How can the REGEXP be app
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT "fo\nfo" REGEXP "^fo$";
How can the REGEXP be applied to a 'SELECT field FROM table' kind of
statement?
Hi,
I am a web developer and I wrote a script that cycles through a bunch
of regular expressions stored in a database.
Is there or will there be a way to precompile and store precompiled
regular expressions in mysql? I would then need to run them against a
string/(var)char field
Hello all,
Is there a mysql function that extracts sub matches from regular
expressions. for example in perl when you match a string to a regular
expression like /\s+(\S+)\s+(\S+)/ the submatches (strings matching the
part of the expression between parenthesis) are available in variables
$1, $2
On Mon, Mar 04, 2002 at 12:25:44PM +0100, Angela Harneit wrote:
> I've a question concerning negations of regular expressions - e.g. I
> want the sentence "this is nice" to match, while the sentence "this
> is not nice" should not match. I only found possibil
Angela,
Monday, March 04, 2002, 1:25:44 PM, you wrote:
AH> I've a question concerning negations of regular expressions - e.g. I
AH> want the sentence "this is nice" to match, while the sentence "this is
AH> not nice" should not match.
AH> I only found pos
I've a question concerning negations of regular expressions - e.g. I
want the sentence "this is nice" to match, while the sentence "this is
not nice" should not match.
I only found possibilities for the negation of single characters on the
MySQL-site, but what about
nt to update 160 records in a table. The field contains a variable
>> value and a constant prefex like
>>
>> 'constant: unique value for this record'
>>
>> Is there such an UPDATE statement that would update this field into
>>
>> 'unique value
rwise is using Perls regular expressions like
(this is rather pseudocode just to make the point)
$foo = 'constant: unique value for this record';
$foo =~ s/constant:(.+)//sg;
$bar = $1; #(and hopefully $1 would hold 'unique value for this record')
UPDATE my_table
SET field = $
Thanks for the patch and the rapid response :)
My application has been running with this patch for 15 hours now - and has
done over 2 million regexp matches without problems :)
Stephen
On Wed, 11 Apr 2001, Michael Widenius wrote:
>
> > "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writ
> "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes:
Stephen> On Tue, 10 Apr 2001, Michael Widenius wrote:
Stephen> Thankyou for the patch - it certainly improves the situation (and fixes
Stephen> the test case I gave) but I seem to have found another problem with regexp
Stephen> :(
on:
> >> > When transfering a database application to use an Alpha Linux server
> >> > rather than intel Linux previously working regular expressions fail to work.
> >> > It appears to be due to a length limit. This effects both binary downloads
> >> &g
y 2.95.2 if you think that would
Stephen> be usefull)
>> [EMAIL PROTECTED] writes:
>> > >Description:
>> >When transfering a database application to use an Alpha Linux server
>> > rather than intel Linux previously working regular expressions fail
> [EMAIL PROTECTED] writes:
> > >Description:
> >When transfering a database application to use an Alpha Linux server
> > rather than intel Linux previously working regular expressions fail to work.
> > It a
[EMAIL PROTECTED] writes:
> >Description:
> When transfering a database application to use an Alpha Linux server
> rather than intel Linux previously working regular expressions fail to work.
> It appears to be due to a length limit. This effects both binary downloa
Hi,
Just a guess, but I expect that the first response will be to use gcc 2.95.2
or later
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 April 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: REXEXP in select only works with short expressions
>Description:
When transfering a database application to use an Alpha Linux server
rather than intel Linux previously working regular expressions fail to work.
It appears to be due to a length limit. This effects both binary downloads
and home compiled distributions.
>How-To-
48 matches
Mail list logo
