some tuning and debugging.
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 2:35 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Need confirmation: Subselects are broken with regards to
index usage?
Hi Robert,
The way non-corre
why this is the case?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 1:11 PM
To: mysql@lists.mysql.com
Subject: Need confirmation: Subselects are broken with regards to index
usage?
I think I'm discovering that sub-selects in MySQL
th ON link.parentID=path.decendantId
WHERE (path.ancestorId = 1)
LIMIT 0,100;
Anyone have any ideas why this is the case?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 1:11 PM
To: mysql@lists.mysql.com
Subject: Need confirmation: Subse
I think I'm discovering that sub-selects in MySQL are broken. Is that
true? It seems like you cannot have a sub-select without doing a table
scan -- even for a constant IN expression -- this because it gets
re-written as an EXISTS that executes for each row.
Is that true? Forcing an index doesn't
I did read in the manual that the field level REFERENCES constraints
on InnoDB tables do not work as expected and one has to first define a
table level index and then create a table-level FOREIGN KEY constraint
for the field to make it work.
I believe this is just a hack to keep things faster...
Hi,
I did read in the manual that the field level REFERENCES constraints
on InnoDB tables do not work as expected and one has to first define a
table level index and then create a table-level FOREIGN KEY constraint
for the field to make it work.
I just would like to know if that's the case with
Asalamualikum
Thank you for contacting. Inshallah we shall try our utmost best to reply to you as
soon as possible.
Wasalaam
Brother Sayful-Islam (Web Team admin)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
> This is an automatic reply to an email you sent to a MySQL mailing address
> protected by our 'self-moderation' system. To reduce the amount of spam
> received at these addresses, we require you to confirm that you're a real
> person before your email will be allowed through.
Just an FYI, I got
Thank you for submitting your request to Quest Software Technical Support. We are
unable to process your request because our records indicate that you are not
registered for Technical Support.
To register, logon to our Supportlink web site http://www.quest.com/support , and
self-register from
Thank you for submitting your request to Quest Software Technical Support. We are
unable to process your request because our records indicate that you are not
registered for Technical Support.
To register, logon to our Supportlink web site http://www.quest.com/support , and
self-register from
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
Subselects will be available in version 4.1
--
Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com
Developing Dynamic Web Applications
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote:
> you are correct - subselects are NOT allowed until version 4
4.1 as opposed to 4.0.x.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 3.23.51
you are correct - subselects are NOT allowed until version 4
until then:
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 ON t1.id = t2.id
OR
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 USING (id)
> -Original Message-
> From: Doug Beyer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Janua
In the last episode (Jan 15), Doug Beyer said:
> It's my understanding that embedded selects are NOT allowed in MySql. Is this
>correct?
>
> Example:
>
> SELECT t1.*
> FROM table1 t1
> WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Correct. Your example can easily be converted to a join,
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?
Example:
SELECT t1.*
FROM table1 t1
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )
Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
[EMAIL PROTECTED]
SAS... The Power to Know
-
Steve Lefevre wrote:
> I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
>
> Users enter a class and it's workshops for their students.
>
> The 'Class' table has fields 'Name' and 'ID'.
> ID is the primary key and its an auto-incremented integer
>
> The 'Workshop' table has a fie
Steve Lefevre wrote:
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
Users enter a class and it's workshops for their students.
The 'Class' table has fields 'Name' and 'ID'.
ID is the primary key and its an auto-incremented integer
The 'Workshop' table has a field ID, Num
Lefevre; [EMAIL PROTECTED]
Subject: Re: INSERT confirmation? PHP
Peter Lovatt wrote:
>mysql_insert_id
>should do it!
>
>
According to documentation somewhere, last insert can sometimes return a
different value than the most recent insert if the most recent insert
failed.
What is a bet
At 20:08 -0500 12/14/02, Michael T. Babcock wrote:
Peter Lovatt wrote:
mysql_insert_id
should do it!
According to documentation somewhere, last insert can sometimes
return a different value than the most recent insert if the most
recent insert failed.
Why is this a problem? If the most rec
Peter Lovatt wrote:
mysql_insert_id
should do it!
According to documentation somewhere, last insert can sometimes return a
different value than the most recent insert if the most recent insert
failed.
What is a better solution?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibr
-1473
International +44-121-242-1473
---
-Original Message-
From: Steve Lefevre [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2002 21:28
To: [EMAIL PROTECTED]
Subject: INSERT confirmation? PHP
I'm designing a user database for PHP 4 and MySQL
I'm designing a user database for PHP 4 and MySQL 3.32 or whatever.
Users enter a class and it's workshops for their students.
The 'Class' table has fields 'Name' and 'ID'.
ID is the primary key and its an auto-incremented integer
The 'Workshop' table has a field ID, Number, ClassID, Date, etc.
- Original Message -
From: Yahoo! Groupes
<[EMAIL PROTECTED]
r>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 10:56 PM
Subject: Demande de confirmation d'inscription à mysql-france
Bonjour,
Nous avons reçu votre demande d'inscription au groupe
mysql-fra
Bonjour,
Nous avons reçu votre demande d'inscription au groupe
mysql-france sur Yahoo! Groupes, le nouveau service de
communautés de Yahoo!. Pour vous inscrire, vous devez confirmer votre
demande en répondant à ce message.
Si vous n'avez pas demandé ou ne souhaitez pas vous inscrire au groupe
At 14:18 01/10/2001 -0400, melissa allman wrote:
Hi,
If you link the MySQL table using MyODBC you can build an Append
Query on Access which inform you the number of rows from the
record set and at the end the number of rows which had successfully
processed.
If you want to avoid duplication of reco
Hi,
I am working on a project that involves using a form to populate a MYSQL
table.
I then need to transfer these records to an Access database. I want to have a
flag on the MYSQL table to indicate that the record was successfully sent to
Access.
It could be an on/off or Y/N value. I am trying
At 10:19 4-4-01 -0600, Nathan wrote:
>I sincerely hope this is the result of a virus.
Dunno, one of the PHP lists is also being harrased by this kind of
messages.. Perhaps Billy boy G. has to much time to spend ;-)
Or it might be a programm in a nasty loop.
The PHP list admin has blocked all tr
Unfortunately not it's plain old SPAM!
It's on other lists as well.
Andy Woolley
www.databasewatch.com
- Original Message -
From: "Nathan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 5:19 PM
Subject: Re: TheCasino.com:
Under the laws of the State of Washington spamming is illegal.
RCW 19.190.040
Violations -- Damages.
(1) Damages to the recipient of a commercial electronic mail message
sent in violation of this chapter are five hundred dollars, or actual
damages, whichever is greater.
(2) Damages to an intera
I sincerely hope this is the result of a virus.
# Nathan
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 8:54 AM
Subject: TheCasino.com: Registration Confirmation
TheCasino.com - Serving ''Winners'
TheCasino.com - Serving ''Winners'' Since 1999!!
Dear MySQL List,
Congratulations and welcome to TheCasino.com!!
To confirm, you have successfully registered as a Real Player. From
now on, every time you log on your Email Address will appear automatically.
And for security, you will need t
31 matches
Mail list logo
