Re: Get max ID of each item in a list

each tid in > my 'in' clause that is the max id for that tid.: > > tid:id -> 123:8 for instance. > > Maybe a group by or something? > -- Kévin Labécot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: ON vs. WHERE

clause for conditions that specify how to join tables, and the WHERE clause to restrict which rows you want in the result set." [JS] Thanks for that. I don't know where I read the opposite. Perhaps I was passing a brain-stone. Or maybe in a comment ? :p -- Kévin Labécot www.cv.labecot.f

Re: [X-POST] PHP script to make sure MySQL is up?

and I also don't know how PHP would restart the MySQL service. you can give php permission to run a shell script that kicks off a service restart Exactly. see exec or system call -- Kévin Labécot Analyste Programmeur www.cv.labecot.fr -- MySQL General Mailing List For list archives: ht

Re: Argh! Another Server Has Gone Away

Le 21 févr. 07 à 14:17, Kévin Labécot a écrit : Hi, I know this problem is already on forums and archives but I don't understand mine ! My MySQL Server works well, there are many scripts and website using it, without any problem. Since few days I'm working on a new project a

Argh! Another Server Has Gone Away

_query() I directly win a "Server has gone away". My query is a simple INSERT INTO on an empty table. I already changed my MySQL config to an higher max_allowed_packet and watch all the configuration... I don't find any problem. Other idea ? :/ Sorry to bother you again with t