Is it just me, or is there not a single section for discussing actual MySQL queries? It seems that all the query discussion ends up in the newbie section. Am I right?
It’s too bad that ON (column = column) comes after and not before INNER JOIN table, because if it came before it would make for much cuter code formatting: [sql] SELECT DISTINCT $columns FROM $this->comments ON (comment_post_ID = post_id) INNER JOIN $this->post2cat ON (category_id = cat_ID) INNER JOIN $this->categories WHERE blog = ‘$blog’ AND $criteria [...]
Arrrrre you readyyyyy— for an es Q elllllllll— CHALLENGE!!!!! I have a user table, let’s say with name and zipcode. I can do the following successfully: Select a random user with SELECT * FROM users ORDER BY RAND(UNIX_TIMESTAMP()) LIMIT 1 Select all users, with only 1 from each zipcode, using SELECT * FROM users GROUP [...]
© JJB Blog. Powered by WordPress using the DePo Skinny Theme.