Help for this page

Select Code to Download


  1. or download this
    mysql> describe test;
    +-------+----------+------+-----+---------+----------------+
    ...
    |  2 | second |  2 | second |
    +----+--------+----+--------+
    2 rows in set (0.00 sec)
    
  2. or download this
    mysql> select a.id as a_id, a.title as a_title, b.id as b_id, b.title 
    +as b_title from test a inner join test2 b using(id);
    +------+---------+------+---------+
    ...
    |    2 | second  |    2 | second  |
    +------+---------+------+---------+
    2 rows in set (0.00 sec)
    
  3. or download this
     _  _ _  _  
    (_|| | |(_|><
     _|