MySql-PhpMyAdmin(圖形化介面)-4.查詢練習-聯絡我們的資料表 (ORDER BY LIMIT、COUNT、WHERE IN)

2021-03-03

抓取最後一筆資料

SELECT * FROM `cantact_t` WHERE del ='0' order by pk desc limit 1

查詢喜歡的人數，不喜歡的人數共幾筆

SELECT COUNT(pk) FROM cantact_t where like_web = 1

查詢未回覆的資料

SELECT * FROM `cantact_t` WHERE state='WE' and del = 0 or state='RD' and del = 0

使用 WHERE IN

SELECT * FROM `cantact_t` WHERE state IN('RD','WE') and del = '0'

Yiru@Studio - 關於我 - 意如

Yiru@Studio