Search This Blog

Thursday, July 9, 2009

MySQL QuB - 9th July

To anyone reading this that uses MySQL and Php, you should at this moment go and get a Visual Query Builder right now! I'm starting to believe that the QuB really does simplify your life a lot on MySQl queries. Just look at this query I built with QuB:-

"
SELECT multiply_test.multiply_date, users_info.*, multiply_test.multiply_id, multiply_test.multiply_1, multiply_test.multiply_2, multiply_test.multi_result, max(bids.bids_item_price) AS max_bids_item_price_1
FROM ((multiply_test
INNER JOIN bids ON bids.bids_item_id=multiply_test.multiply_1)
INNER JOIN users_info ON users_info.id=multiply_test.multiply_1)
GROUP BY multiply_test.multiply_date, multiply_test.multiply_id, multiply_test.multiply_1, multiply_test.multiply_2, multiply_test.multi_result, users_info.id, users_info.upl_name, users_info.upl_file, users_info.loc, users_info.users_total_ads, users_info.users_total_earn, users_info.users_total_paid, users_info.users_total_unpaid
ORDER BY multiply_test.multiply_date DESC, max_bids_item_price_1 DESC
"

Seriously hard work there to figure out if you're using hand coding....

No comments: