Grants

2004-09-22 Thread Yann Larrivée
Hi, I juste installed mysq. 5.1 (alpha) and i guess i am facing some really stupid issue :) I logged in as root without probleme create a database xoops which shows when i do a show databases Now i try to give grants to a user on that datase via grant all on xoops.* to [EMAIL PROTECTED]

Re: Grants

2004-09-22 Thread Yann Larrivée
Well i think i found a bug or a change un behavior between mysql 5.0.0 ans mysql 5.0.1 The behavior i describe does not happen. Can anybody else confirm this ? Thanks Yann On September 22, 2004 21:51, Yann Larrivée wrote: Hi, I juste installed mysq. 5.1 (alpha) and i guess i am facing

Re: Complex mysql query

2001-03-28 Thread Yann Larrivée
in txt format so you can take a look at it in TextPad. :-) Thanks for your comments i really appreciate :-) Yann - Original Message - From: "Bob Hall" [EMAIL PROTECTED] To: "Yann Larrivée" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 6:14 AM Subject: Re:

Re: MySQL books

2001-03-28 Thread Yann Larrivée
I got the PaulDubois book , but i made a mistake i bought the transaltion in french. An advice to all others who are thinking of buying it in french if you can buy it in englis , Yann - Original Message - From: [EMAIL PROTECTED] To: "Lindsay Adams" [EMAIL PROTECTED]; [EMAIL

Complex mysql query

2001-03-27 Thread Yann Larrivée
Hi everybody. I got a complexe question well according to me. I am working with PHP and i am making some queries to some database. here is a description of the tables. provider book video music provider_id title title title name provider_id provider_id provider_id

Re: Complexe query ....

2001-03-27 Thread Yann Larrivée
But could i use something like a subselect ... I know they are not supported by mysql but i see in my book that there is a substitute for it. Also i am not to familiar with LEFT JOIN ... and all those ... can you give me explanation ? So really would it make what would be the real answer to my