- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED]
--Sent: Thursday, November 06, 2003 3:41 PM
--To: [EMAIL PROTECTED]
--Subject: select count(*) /
At 15:41 -0800 11/6/03, Hsiu-Hui Tseng wrote:
Hi,
select count(*) is very slow in innodb (because it is a table scan). Is
there any difference if I change it to select count(column).
I did some test and some times select count(*) is really slow and some time
select count(column) is slow. Could
On Tue, 12 Nov 2002 12:02:04 +0100
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
[snip]
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
[/snip]
Current versions of MySQL do not support sub-selects.
HTH!
Jay
You can use JOIN...
See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan
-Original Message-
From: van den Heuvel, Frank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:47 AM
To: '[EMAIL PROTECTED]'
Subject: select in select
Hello,
I would like to do this