After reading one of the recent posts from Gobi [EMAIL PROTECTED]
I took his successful query and modified it for one of my tables. It indeed
produce the correct result, but in the process raised some questions.
1. Why do list_ID and acct_ID not have to be qualified with a table
name
:-)
Rhino
- Original Message -
From: Gordon Bruce [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Friday, November 04, 2005 2:51 PM
Subject: Sub Selects, Alias Names and stored procedures
After reading one of the recent posts from Gobi [EMAIL PROTECTED]
I took his successful query
Hello,
I have a question that someone here may or may not be able to answer (I
think perhaps MySQL is incapable of a solution). I have a program which
uses a MySQL database to help create a playlist for a ShoutCast stream.
There is a web site associated with the web-radio. Users of the
Hello,
I have a question that someone here may or may not be
able to answer (I
think perhaps MySQL is incapable of a solution). I have a
program which
uses a MySQL database to help create a playlist for a
ShoutCast stream.
There is a web site associated with the web-radio. Users
On Wed, 28 Jan 2004, Deven Phillips wrote:
Hello,
There is a web site associated with the web-radio. Users of the web site
can rate songs which are contained in the database. The rating system
works such that users can rate songs from +3 to -2. Now, what I would
like to accomplish is to
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects, but i haven't found the correct syntax... Does any one know
how to do this?
I need someting like this:
Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
# [EMAIL PROTECTED] / 2003-09-24 02:32:10 -0600:
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects
According to what documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagle
[EMAIL PROTECTED] wrote:
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects, but i haven't found the correct syntax... Does any one know
how to do this?
I need someting like this:
Select a, (select sum(b) from T2 where T2.a=T1.a) as b from T1
In MySQL 4.1
* fbeltran
According to documentation, in MySQL version 4.0, it is possible to use
sub-selects, but i haven't found the correct syntax...
Like others have said, it's from version 4.1:
URL: http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html
Does any one know how to do this?
I need
Hi Mysql List,
Will all mysql versions (std, max and debug) from 4.1 support sub selects or
will this only be included f.e in the max version ?
Best regards
--
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
--
MySQL General Mailing List
Nils Valentin [EMAIL PROTECTED] wrote:
Will all mysql versions (std, max and debug) from 4.1 support sub selects or
will this only be included f.e in the max version ?
In all.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems
they cause!
somewhere on mysql.com is said:
sub-selects need mysql version 4.1 and up!
BUT:
i have a statement
insert into foo select bar from bartable;
this thing works if i enter it on the mysql-shell. (also
Does the PHP user have insert authority?
grant insert,alter,select on theTable to phpuser;
you mean this? php user is the user with whom the php file connects
to the db right?
i executed every statement from the shell as that user,too!
best regards
udo
--
MySQL General Mailing List
You did not show us your actual insert statement, but
You can not insert into a table listed anywhere in the select.
Udo Schubert wrote:
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems
they cause!
somewhere on mysql.com is said:
sub-selects need mysql
You did not show us your actual insert statement, but
You can not insert into a table listed anywhere in the select.
sorry,man. i should have been given you the whole thing:
here it comes:
db one with table person
(firstname,name,email,phone,fax,hashval,flag,etc...) and table hashvalue
daniel,
Monday, November 11, 2002, 3:51:25 AM, you wrote:
d will 4.1 hopefully have stored procedure functionality ?
Nope.
Stored procedures will be implemented around v5.0
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
: Monday, November 11, 2002 11:16 AM
Subject: Re: MySql 4.1 Sub Selects
Greg Matthews wrote:
clause) instead of EXISTS -- seems like a tail wagging the dog
strategy.
Isn't EXISTS a lot more efficient than an inner join?
Well, its more efficient if it exists, I guess
: Monday, November 11, 2002 11:00 PM
To: [EMAIL PROTECTED]
Subject: re: RE: MySql 4.1 Sub Selects
daniel,
Monday, November 11, 2002, 3:51:25 AM, you wrote:
d will 4.1 hopefully have stored procedure functionality ?
Nope.
Stored procedures will be implemented around v5.0
--
For technical support
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 11 November 2002 13:03, Richard Morton wrote:
according to this link... 4.1 will have stored procedures
http://www.mysql.com/products/mysql-4.0/index.html
Oops, that page needs to be updated. Stored procedures will come with
MySQL 5.0,
,
Greg.
- Original Message -
From: Dan Rossi [EMAIL PROTECTED]
To: Victoria Reznichenko [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, November 11, 2002 11:04 PM
Subject: RE: RE: MySql 4.1 Sub Selects
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i
could
program
Message-
From: Greg Matthews [mailto:greg55;ozemail.com.au]
Sent: Monday, November 11, 2002 7:38 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: MySql 4.1 Sub Selects and not stored procedures
hey, can i hijack my message back?...this thread is about the performance of
subselects, not stored procedures
Dan Rossi wrote:
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i could
program some c ++ to hurry it along a bit, i dont really have access to DB's
like oracle to learn stored procedure stuff
Don't forget that with MySQL, you can link in external procedures though
...
In the last episode (Nov 11), Greg Matthews said:
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
: Tuesday, November 12, 2002 12:02 AM
Subject: RE: RE: MySql 4.1 Sub Selects and not stored procedures
I'm not sure where you're getting your information (Typically, db vendors
recommend you use an exists clause, not a join when testing for the
presence
of child data because it's faster
11:04 PM
Subject: RE: RE: MySql 4.1 Sub Selects
damn , i read it was 4.1 i guess we have to wait a bit then, i wish i
could
program some c ++ to hurry it along a bit, i dont really have access to
DB's
like oracle to learn stored procedure stuff
-Original Message-
From
On Sun, Nov 10, 2002 at 05:51:43PM +1100, Greg Matthews wrote:
It would be a huge help to get hold of MySql 4.1.
What's shaken out mean? Is 4.1 still mid-development, or is it in
alpha, more or less finished, and needs debugging?
Is there anyway soon that someone could build and release
optimised (it will be started after finishing
main subselect constructions).
Regards,
Jocelyn
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Greg Matthews [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 10:00 AM
Subject: Re: MySql 4.1 Sub Selects
: [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 9:00 PM
Subject: Re: MySql 4.1 Sub Selects
On Sun, Nov 10, 2002 at 05:51:43PM +1100, Greg Matthews wrote:
It would be a huge help to get hold of MySql 4.1.
What's shaken out mean? Is 4.1 still mid-development, or is it in
alpha, more
On Sun, Nov 10, 2002 at 09:29:52PM +1100, Greg Matthews wrote:
Jeremy,
I'm not a C/C++ coder so couldn't really help unless a binary was
available.
At the same time, I understand that you'd be wasting your time building
binaries unless you were happy that the code was at a certain level
, 2002 11:16 PM
Subject: Re: MySql 4.1 Sub Selects
In article 014701c288a4$1b1bb550$0100a8c0@dev,
Greg Matthews [EMAIL PROTECTED] writes:
Your call. If a 4.1 binary was available then I'd spend time testing it
with
a J2EE app under JBoss on Windows XP -- otherwise i'll just have to
wait
Greg Matthews wrote:
clause) instead of EXISTS -- seems like a tail wagging the dog strategy.
Isn't EXISTS a lot more efficient than an inner join?
Well, its more efficient if it exists, I guess ... but if it doesn't
exist on your platform (MySQL), then its pretty inefficient, really.
We're
: 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) instead of EXISTS -- seems like a tail wagging the dog
strategy.
Isn't EXISTS a lot more
consideration of
sometimes putting DISTINCT in the select statement.
Thanks a lot,
Greg.
- 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
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/
On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote:
All,
Anyone have any rough idea when 4.1 (with SubSelects) is due to be released?
Well, if you pull the source code, it's there. But I suspect it'll be
a few months before you start seeing pre-built binaries available.
There's a
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
On Sun, Nov 10, 2002 at 03:45:04PM +1100, Greg Matthews wrote:
All,
Anyone
// This is a generic function which returns the results
// of a query in list form, so they can be used in place
// of nested queries until it is implemented in MySQL
// If there are no values, it returns the string
// Empty Nested Set by default.
function getnestedvals($field, $table,
Hi All! This is my first question to the list. Can some one help out a
newbie with a simple question please? The closest thing I found is a php
query to do this using temporary tables but it takes too long.
Table 1
NameDate
John01/10
Jack01/10
Jill01/10
Mary02/10
John
Message -
From: Darley, Terry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 20, 2002 10:29 AM
Subject: Sub-selects
To Whom It May Concern:
I've just joined the mailing list for problem sharing/helping and the
first
2 e-mails I received, demonstrates a need for sub-selects
11:35 AM
To: Darley, Terry; [EMAIL PROTECTED]
Subject: Re: Sub-selects
Take a look at:
http://www.mysql.com/doc/T/O/TODO.html and
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
You can do what you want to do easily by using an API (PHP, Perl, etc.) Is
it possible for you to use
I'm a comparative MySQL newbie who is struggling with sub-selects. In
other DBMS's, I can use sub-selects to return a set that I can use in a
condition of a WHERE clause. An example is the recent query by Ciprian
Trofin about finding the cheapest price of a product. In other DBMS's
I would use
Hi.
That's an FAQ and explained in the tutorial:
http://www.mysql.com/doc/e/x/example-Maximum-row.html
Regards,
Benjamin.
On Tue, May 28, 2002 at 12:05:19PM +0100, [EMAIL PROTECTED] wrote:
I'm a comparative MySQL newbie who is struggling with sub-selects. In
other DBMS's, I can use
WHERE condition AND id NOT IN (SELECT id FROM tblcount);
However, thanks to off-list correspondence, I now know that I need to
do some research into temporary tables because these can provide most
(if not all) the functionality of sub-selects.
Thanks again to all,
--
Geoff Lane
Cornwall, UK
[EMAIL
i have to use a statement like:
SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1
AND CODICEALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE
(CODICE_ARCHIVIO=342))
but mysql doesn't support inner select.
What statement should i use instead of this one ?
Thanks...
Alex.
Alex [EMAIL PROTECTED] schrieb im Newsbeitrag
news:aatd8o$1jhk$[EMAIL PROTECTED]...
i have to use a statement like:
SELECT CODICE FROM TABSIC WHERE COM=1 AND SEN=1 AND PRI=1
AND CODICEALL(SELECT CODICE_TABSIC FROM ARCHIVIO_SICU_MIN WHERE
(CODICE_ARCHIVIO=342))
but mysql doesn't support
clause will
filter these out.
Check out LEFT [OUTER] JOIN in the manual...
From: [EMAIL PROTECTED]
To: Mysql. Com [EMAIL PROTECTED]
Subject: sub selects
Date: Mon, 22 Apr 2002 15:34:22 +0100
I know that mysql does not support sub selects but I want to be able to do
the following:
I have
I know that mysql does not support sub selects but I want to be able to do
the following:
I have a table with all my leads in called leads. The table has a unique ref
for each lead called refnumberid
I have a table with leads in and products that leads have asked not to be
mailed on the table
: PPSlim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 02, 2002 4:52 AM
To: [EMAIL PROTECTED]
Subject: Do not understand a method without sub-selects
I have one single table, logging site activity as a security precaution.
I want to generate a report, including items of a certain type
I have one single table, logging site activity as a security precaution.
I want to generate a report, including items of a certain type, but only if a seperate
type has not taken place
after the timestamp within the first type.
log_data_sig
can you perform sub selects in mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
no, but you can acheive the same results
please consult the manual
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Etienne
Joel Wickard wrote:
can you perform sub selects in mysql?
-
Before posting, please
no
-Original Message-
From: Joel Wickard [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subject: sub selects
can you perform sub selects in mysql?
-
Before posting, please
As far as I know, not yet
Joel Wickard wrote:
JW: Date: Fri, 14 Dec 2001 12:50:39 -0800
JW: From: Joel Wickard [EMAIL PROTECTED]
JW: To: [EMAIL PROTECTED]
JW: Subject: sub selects
JW:
JW: can you perform sub selects in mysql?
JW:
JW:
JW
At 12:50 -0800 2001/12/14, Joel Wickard wrote:
can you perform sub selects in mysql?
The quick answer is coming soon.
Please see:
http://www.mysql.com/doc/D/i/Differences_from_ANSI.html
and
http://www.mysql.com/doc/T/O/TODO_future.html
HTH
/Rob
(sorry for the double-post, but I had wrong subcect on the previous one)
Hi
I having a little trouble with mysql, with the lack of sub-selects.
Yes, I have read about joins, both the manual and from the MySQL book by
Paul Dubois, but none of those provide any 'real' info about what to do
hello,
I'm running mysql 3.23.39. Could anybody explain me how to do this in mysql
(without sub-selects):
delete from IP where id in ( select id from USERS where MK='0032' )
Thanks.
.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org
Andrius Armonas [EMAIL PROTECTED] wrote:
I'm running mysql 3.23.39. Could anybody explain me how to do this in
mysql
(without sub-selects):
delete from IP where id in ( select id from USERS where MK='0032' )
One solution is to build a list of id values from the users table in your
As I've understood it mysql doesn't support sub-selects inside for example
insert statements
(apart from inset ... select).
Background-stuff:
What I'm working on is parsing logfiles and inserting them into a mysql
database through the C API,
to minimize traffic and to maximize time, I
This is how I'd like the query to work:
insert into host (host_id, host_IP) values ((select from mail
mail_id where
mail_addr = [EMAIL PROTECTED]), '127.0.0.1')
Try:
insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail
where mail_addr = '[EMAIL PROTECTED]';
Gunnar Ingvi writes:
Hi there !
I?m wondering if there is planned support for Sub-Selects
(e.g. HAVING and so on) in upcoming versions? I think
this is very important to implement.
Best regards,
Gunnar Ingvi
[EMAIL PROTECTED]
Hi!
It will come in version 4.1.
Regards
Hi,
I am guessing this is the kind of problem that would be easier to solve with
a sub select
SELECT
simpleparts.category,simpleparts.partnumber,simpleparts.manufacturer,simplep
arts.descrp,ABS(packagesParts.pri) as abPRI,categories.sortorder
FROM ((packagenames LEFT JOIN packagesParts ON
Hi Eric,
I'll second Bob Hall's opinion.
One could extend a query so that it checks also your additional condition.
You haven't gotten to the 'group by' and 'having' goodies, that's the hint.
But this would make it over-complicated,
and MySQL could run into problems when attempting to evaluate
62 matches
Mail list logo