Help for this page

Select Code to Download


  1. or download this
    mysql> desc poll;
    +-------+------------------+------+-----+---------+----------------+
    ...
    | id    | int(10) unsigned |      | PRI | 0       | auto_increment |
    | poll  | varchar(50)      |      |     |         |                |
    +-------+------------------+------+-----+---------+----------------+
    
  2. or download this
    mysql> desc poll_votes;
    +---------+------------------+------+-----+---------+----------------+
    ...
    | poll_id | int(10) unsigned |      |     | 0       |                |
    | address | varchar(50)      |      |     |         |                |
    +---------+------------------+------+-----+---------+----------------+
    
  3. or download this
    mysql> select * from poll;
    +----+--------+
    ...
    |  2 |       2 | junk     |
    |  3 |       2 | morejunk |
    +----+---------+----------+
    
  4. or download this
             select p.poll 
               from poll p 
    left outer join poll_votes pv 
                 on pv.poll_id=p.id and pv.address='junk' 
              where pv.poll_id is null;
    
  5. or download this
    +------+
    | poll |
    ...
    | C    |
    | C++  |
    +------+