Re: Excluding records that don't match condition

2009-09-25 Thread James Fryer
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

Excluding records that don't match condition

2009-09-24 Thread James Fryer
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

Query that crashes MySQL

2004-04-20 Thread James Fryer
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

RE: Query that crashes MySQL

2004-04-20 Thread James Fryer
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]

RE: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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

CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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

RE: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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

RE: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread 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

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

2003-08-14 Thread James Fryer
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