MySQL中UNION与ORDER排序同时使用
例如这样的语句：select * from table1 where name like '%name1%' order by ID ASC union select * from table2 where name like '%name2%' or ...
Emlog搜索优化2 - 标题+全文搜索
前段时间写了emlog搜索功能添加全文搜索功能：https://www.mmuaa.com/post-215.html但是效果并不是很好，比如搜索python的时候，一些与python无关，只是在文中提到一下，在搜索中就会被排序到上面。我们想要解决的是，希望标题中出现关键字的文章 ...
PAT-A 真题- 1079. Total Sales of Supply Chain
原题干：A supply chain is a network of retailers（零售商）, distributors（经销商）, and suppliers（供应商）-- everyone involved in moving a product from supplier to customer.Starting from one root supplier, everyone on the chain ...
PAT-A 真题- 1036. Boys vs Girls
原题干：This time you are asked to tell the difference between the lowest grade of all the male students and the highest grade of all the female students.Input Specification:Each input file contains one test case. Each case conta ...
PAT-A 真题- 1011. World Cup Betting
原题干：With the 2010 FIFA World Cup running, football fans the world over were becoming increasingly excited as the best players from the best teams doing battles for the World Cup trophy in South Africa. Similarly, football bet ...