Change mysql date type into another date format with mysql’s date_format function

Posted by Shek on April 12, 2011 under MySQL | Be the First to Comment

MySQL’s date field type default is in yyyy-mm-dd format, and it is not practical in some cases when we want to use another formating representation such as dd/mm/yyyy. Of course we could use PHP to convert it but the best way I find is to convert it through SQL before any php operation, here is an example which I which like to show you:
Read more of this article »

SQL – join 2 mysql tables and get data result from them

Posted by Shek on March 16, 2011 under MySQL | Be the First to Comment

In this post, I am going to talk about how to get data from 2 mysql tables instead of 1 table with a sql.

Here are 2 mysql tables (The field types are ignored in this examples): Read more of this article »