as far as i know, mysql version 4.0 and previous, do not support subqueries.
Select in select doesn't work.
Have a look in the manual if what u r trying to do is supported.
George Christoforakis.
PS: You don't mention your mysql version. Is this sql the exact command?
- Original Message
select * from TableName LIMIT NumberOfRows
George Christoforakis
- Original Message -
From: Maurice Coyle
To: [EMAIL PROTECTED]
Sent: Friday, June 27, 2003 12:34 PM
Subject: very long query time
hi all,
i have a table in my mysql database with around 66
Erm, the first sql as i can see doesn't connect on the same field as the
second one that produces the correct result.
George Christoforakis
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:01 AM
Subject: Join vs. Where (help
use double quotes in internal quotes... so it dhould be something like:
select * from lyric where album like '%Blind Man\''s Zoo%'
I think it'll work.
George Christoforakis.
- Original Message -
From: Weston Skeans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 15, 2003 8
Hello,
anybody knows if I can setup the memory usage under MySQL 4.1.0?
I need to set the min and max otherwise my pc gets really slow because I load a huge
script on MyCC.
thanks
George Christoforakis
work.
Any ideas?
I have to use this version of MySQL as it succefully supports the
SubSelects.
Thanks
George Christoforakis.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]