BAUMEISTER Alexandre writes:
> Sinisa,
>
> >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'xxxxxxxxxxxxxxxx' |
> >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
> |
> >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%'
> |
> >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%'
> |
> >> >>
>+----------------------------------------------------------------------------------------+
> >>
> >> But the query is :
> >>
> >> SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE
>n.id=s.news_id AND i.symbole=s.symbole AND n.id=xxxx LIMIT 1
>
> SM> In which database are tables news, symbole_news ??????
>
> In database "contenu".
>
> Alex.
>
>
Hmmmm.........
xmells like my bug .......
I will take a look at it ...
It is a bug induced by db.table notation, which should work in the
above case.
Why didn't you come up with it one week ago and thus helped us fix
this in 3.23.40 ...... ;o)
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
