Welcome to Hexo! This is your very first post. Check documentation for more info. If you get any problems when using Hexo, you can find the answer in troubleshooting or you can ask me on GitHub.
SELECTCOUNT(abbr) FROM Organisms; --统计表中全部记录的数目 SELECTCOUNT(abbr) FROM Organisms WHERE abbr LIKE'a__'; --统计abbr以「a」开头,共3个字符长的记录数 COUNT(abbr) ----------- 232 SELECTCOUNT(abbr) FROM Organisms WHERE abbr LIKE'a%'; --统计abbr以「a」开头的所有记录数 COUNT(abbr) ----------- 258