are right, EXISTS is what I want. Thanks,
James
--
James Fryer / j...@invocrown.com / j...@cix.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
so there may be
something I have overlooked.
Many thanks in advance,
James
--
James Fryer / j...@invocrown.com / j...@cix.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to post a bug report I need to winnow down my tables and data to
the minimum, which will take some effort. So before I do this, I'd like to
ask if anyone else has seen this problem and if there is a fix.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
rows in set (0.00 sec)
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:19 am 14/08/03, Jim Smith wrote:
I repeat. Why do you need the parentheses? Union queries don't require them.
Sorry, missed this.
They do need them if you want to use ORDER BY on the result of the UNION.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General
INTO.
Is this a bug? I can't find it documented anywhere.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error)
CREATE TABLE Foo2 (SELECT * FROM Bar);
DROP DATABASE Foobar;
-- Cut Here --
Using MacOS so please forgive any errors due to case-sensitivity.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
is, why do the parentheses cause a syntax error and is this a bug?
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:28 am 14/08/03, Sergei Golubchik wrote:
It's in the 4.0.14 changelog, and thus, is available in 4.0.14
Hmm, I am using
Ver 13.5 Distrib 4.1.0-alpha, for apple-darwin6.4 (powerpc)
which I should have said in the first place, sorry. So it ought to be
working?!?
Jim
--
James Fryer
At 10:19 am 14/08/03, Jim Smith wrote:
Are you saying that any query containing parentheses fails?
No. Any query beginning with a SELECT statement in parentheses.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10)
ORDER BY a;
which is what I am doing.
The problem seems to be with the syntax of CREATE TABLE and INSERT INTO,
not the syntax of UNION.
Jim
--
James Fryer / [EMAIL PROTECTED
11 matches
Mail list logo