MySQL - karate405 @Wiki

Inner Join Query

There are two tables here for example "tak" and "tak2".
table tak

mysql> select * from tak where name ='take';
+----+------+-----------+
| id | name | tel       |
+----+------+-----------+
|  1 | take | 721255304 |
+----+------+-----------+

table tak2

mysql> select * from tak2 where id ='1';
+----+--------------+-----------+--------+
| id | address      | post_code | linked |
+----+--------------+-----------+--------+
|  1 | tondabayashi | 584-0036  |      1 |
+----+--------------+-----------+--------+

And here is an example of using "inner join"

mysql> select name, tel, address, post_code from tak 
       inner join tak2 on tak.id = tak2.linked;
+------+-----------+--------------+-----------+
| name | tel       | address      | post_code |
+------+-----------+--------------+-----------+
| take | 721255304 | tondabayashi | 584-0036  |
+------+-----------+--------------+-----------+

reference URL : http://www.pursue.ne.jp/SQLDoc/select19.htm

INTERVAL Exsample

There is a way to perform sql date management

e.g MySQL with PHP

for(i=0;$i<count($dateArray); $i++){
    $sql = "SELECT * FROM TEST WHERE DATE = '".$dateArray[$i]."'";
   }

using INTERVAL method

$sql = "SELECT * FROM TEST WHERE DATE BETWEEN (SELECT 'DATE' - INTERVAL 10 DAY) AND DATE";