Shorthand for MySQL JOIN

Hey guys, i am currently finishing my degree at collage and do not have a lot of time to write as you can see. Last month was short on post and i believe that this month will also be short, although i have already long list of topics i want to write about. Anyway i managed to find some time so here something interesting i found recently.

If you are like me then you probably go by the rule: less is more. I prefer to less code because it usually make applications more transparent and easy to review code later. So here is is shorthand for MySQL joins i found recently on some blog (sorry do not remember where), oh and by the way i assume you know how to use joins .

Usually if you want to JOIN two tables you would/could write such query:

SELECT * FROM table1 AS t1 LEFT JOIN table2 AS t2 
ON t1.id=t2.id AND t1.color=t2.color;

Not many MySQL developers know about it, or maybe i am the one who do not know about it but the same query can be written with less code:

SELECT * FROM table1 LEFT JOIN table2 USING (id, color);

Neet right? Arguments for USING() function is a list of columns to use for join statement, well i guess that’s, all there is nothing really to explain here, it is best to just compere those two statements.

That’s it for now, but one thing i have to mention i left this blog for like two or three weeks without a post and i guess spammers thought it is already abondened and within this three weeks there was over 3000 spam comments made, i do not think i will be going thru all this, i will just delete all, so if you left me an interesting comment and i will delete then … SORRY.

Update.

Actually i went thru all this, first i went to the phpMyAdmin and deleted over 2500 spam messages with only three queries ;> so there was only 300 comments left. So i manually seperated spam from real comments, only to find out that … there was only ONE real comment … that sucks :].