MySQL 3.23.58 and sub-seletcs

[boka]

Hi !

Are sub-selects supported by MySQL 3.23.58, because below query does not 
work (syntax error in console):

select iphdr.ip_src, timestamp \
from iphdr , acid_event  \
where iphdr.sid = acid_event.sid \
and iphdr.cid = acid_event.cid \
and acid_event.sig_name = STATEMENT \
and acid_event.timestamp  select max(another_database.dataz.timestamp) 
\ from  another_database.dataz;

greetz
boka
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 3.23.58 and sub-seletcs

[boka]

Bob Brands wrote:

No, its supported by version 4.1
MySQL 4.1 -- Alpha release (use this for new development) ... is this 
stable enough to use it on production systems ?

btw. is there any workaround for this functionality in 3.23.58 ?

greetz
boka
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The host or user argument to GRANT is too long ??!!!

[boka]

Hi !

I have tried to find a solution to my problem on groups, FAQs, with no
effect.

GRANT Select,Insert,Update,Delete ON `sprzet`.* TO
- 'azsxdcfv_azsxdcfvgb''azs.azsxdcfvg.az';
ERROR 1145: The host or user argument to GRANT is too long

hmm ...

mysql show columns from user;
+-+-+--+-+-+---+
| Field   | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| Host| char(60) binary |  | PRI | |   |
| User| char(50) binary |  | PRI | |   |

...

conf:
MySQL-3.23.55

-- 
May the source be with you...
Pozdrawiam
mailto:boka(at)sto-procent.art.pl


-
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]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php