select crap from blahblah where nobody_is_interested = 'Y'
sql,query
- Original Message -
From: "Sameh Attia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 7:32 PM
Subject: Re: InnoDB vs. MySQL performance Issue
> Sam Przyswa wrote:
>
> >Sameh Attia ([EMAIL
'Air Force')
- Original Message -
From: "Greg Matthews" <[EMAIL PROTECTED]>
To: "Richard Forgo" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 01, 2003 9:29 AM
Subject: Re: simple (I thought) delete question
> i
if you want to do it in one statement, you'll need to wait for subselects to
be implemented in MySql. Apparently this is underway and was scheduled to
appear in MySql 4.1
if subselects were supported, you'd do something like this:
delete from tids where exists ( select 1 from tids_admin where tid
lso fail, and yes,
there is a directory called c:\mysql
Any help much appreciated,
Greg.
PS. Using the standard IP-based connection (i.e. not named-pipes) seems to
kick MS Sql Servers arse in terms of speed.
- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
To:
All,
The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.
JBoss (www.jboss.org) stores datasource definitions in XML files, and so
using & seems a bit problematic.
Is there any way that the supported delimiters can be extended to use a
semi-colo
ok, just answering my own question here.
found it.
"describe " contains "auto_increment" in the "extra" column,
which gives me what I want.
sql,query
- Original Message -
From: "Greg Matthews" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&g
All,
I'd like to be able to query MySql using the JDBC driver to determine which
tables have auto incremented columns.
In MSSQL I can retrieve data from the syscolumns and sysobjects tables to
find out which columns are IDENTITY columns, but have had no luck trying to
do something similar in MySq
4.0 can be downloaded now and supports RI -- if your tables are InnoDB
tables, and you create indexes on the fk columns.
The online mysql manual has a lot of information on how to setup InnoDB
tables -- chapter 7.
Greg.
- Original Message -
From: "Hernan Seivane" <[EMAIL PROTECTED]>
To:
the question was:
> Do any MySql coders writing subselects in 4.1 know whether EXISTS will
outperform an equivalent query written as a join. <=
yes or no ?
greg.
- Original Message -
From: "Arthur Fuller" <[EMAIL PROTECTED]>
To: "Greg Matthews&qu
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures. go write your own message :-)...
sothe original question is if someone would be nice enough to answer..
> Do any MySql coders writing subselects in 4.1 know whether EXISTS will
-- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Greg Matthews" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 11, 2002 11:16 AM
Subject: Re: MySql 4.1 Sub Selects
> Greg Matthews wrote:
>
> >clause) in
d Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 11:16 PM
Subject: Re: MySql 4.1 Sub Selects
> In article <014701c288a4$1b1bb550$0100a8c0@dev>,
> "Greg Matthews" <[EMAIL PROTECTED]> writes:
>
> > Your call.
eB
where tableB.myCol = tableA.myCol
)
or
select from tableA
where exists (
select 1
from tableB
where tableB.myCol = tableA.myCol
and tableB.someCol in ('A','B','C')
)
Regards,
Greg.
- Original Message -----
From: "Jeremy Zawodny&quo
is in a semi-usable state.
Greg.
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Greg Matthews" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 4:21 PM
Subject: Re: MySql 4.1 Sub Selects
>
All,
Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Thanks,
Greg.
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
15 matches
Mail list logo
