Re: Excluding records that don't match condition

believe you 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

ten to use JOINs? It seems hard to me because all the keywords need to be examined to eliminate the title. On the other hand it must be a common requirement 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

RE: Query that crashes MySQL

xtra: Using where; Using index; Distinct 4 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]

Query that crashes MySQL

n unacceptably. In order 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]

Re: CREATE TABLE, INSERT INTO with SELECT in parentheses

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

RE: CREATE TABLE, INSERT INTO with SELECT in parentheses

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

# Fails (syntax 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.mys

CREATE TABLE, INSERT INTO with SELECT in parentheses

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

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

RE: CREATE TABLE, INSERT INTO with SELECT in parentheses

, 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

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 Ge