下面小編就為大家?guī)硪黄胢ysql 查詢奇偶數(shù)的實例代碼。小編覺得挺不錯的，現(xiàn)在就分享給大家，也給大家做個參考。一起跟隨小編過來看看吧
1：查找id為奇數(shù)的行
引用
mysql>?select?*?from?forum_dummy?where?id&1?; +----+-----------+------------+ |?id?|?user_name?|?dummy_name?| +----+-----------+------------+ |??1?|?yang??????|?ting???????| |??3?|?yang3?????|?ting3??????| +----+-----------+------------+ 2?rows?in?set?(0.00?sec)
2：查找id為偶數(shù)的行
引用
mysql>?select?*?from?forum_dummy?where?id=(id>>1)<p><span style="font-family:'hiragino sans gb w3','hiragino sans gb',arial,helvetica,simsun,u5b8bu4f53; font-size:16px; line-height:28px">3：conv 函數(shù)：二進制，八進制，十六進制，十進制之間的轉換</span><br><span style="font-family:'hiragino sans gb w3','hiragino sans gb',arial,helvetica,simsun,u5b8bu4f53; font-size:16px; line-height:28px">1）二進制--》十進制</span><br><span style="font-family:'hiragino sans gb w3','hiragino sans gb',arial,helvetica,simsun,u5b8bu4f53; font-size:16px; line-height:28px">引用</span><br><span style="font-family:'hiragino sans gb w3','hiragino sans gb',arial,helvetica,simsun,u5b8bu4f53; font-size:16px; line-height:28px"></span></p><pre class="brush:sql;toolbar:false">mysql>?select?conv(101010,2,10); +-------------------+ |?conv(101010,2,10)?| +-------------------+ |?42????????????????| +-------------------+ 1?row?in?set?(0.00?sec) 2）十進制--》十六進制 引用 mysql>?select?conv(999,10,16); +-----------------+ |?conv(999,10,16)?| +-----------------+ |?3E7?????????????| +-----------------+ 1?row?in?set?(0.00?sec)
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
