卢克治-BJTU-NLP-的博客

在通过datagrip连接mysql的时候，突然出现failed，提示如下：null,  message from server: "Host '192.168.2.203' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"原因：同一个ip在短时间内产生太多（超过mysql数据库...

select * from book where book_nameregexp ‘123|456|354’;#匹配任意一个字符串正则表达式查询select * from book where book_nameregexp ‘^php’; 字符串开头regexp ‘php$’; 字符串结尾regexp ‘p.’; #匹配任意一个字符regexp ‘[abc]’; ...