Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Printing even rows :
- set @rownum := 0;
- select cool,uname,handle from (select uname,handle,@rownum := @rownum+1 cool
- +------+-----------------+---------+
- | cool | uname | handle |
- +------+-----------------+---------+
- | 1 | Bhupendra Yadav | bhupixb |
- | 3 | Sachin Yadav | xorawar |
- | 5 | Sachin Yadav | xorawar |
- +------+-----------------+---------+
Add Comment
Please, Sign In to add comment
