Advertisement
poncha

Untitled

Feb 7th, 2013
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. mysql> create table t ( id int(10) not null default 0, po int(10) not null default 0);
  2. Query OK, 0 rows affected (0.04 sec)
  3.  
  4. mysql> insert into t set id=1,po=1;
  5. Query OK, 1 row affected (0.00 sec)
  6.  
  7. mysql> insert into t set id=2,po=1;
  8. Query OK, 1 row affected (0.00 sec)
  9.  
  10. mysql> SELECT po,id FROM t GROUP BY po;
  11. +----+----+
  12. | po | id |
  13. +----+----+
  14. | 1 | 1 |
  15. +----+----+
  16. 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement