- 博客(6)
- 资源 (4)
- 收藏
- 关注
原创 Java - 正则表达式的运用(Pattern模式和Matcher匹配)—— 匹配中文,英文字母和数字及_长度详解——收集资源blog
java.util.regex.Pattern 模式类:用来表示一个编译过的正则表达式。java.util.regex.Matcher 匹配类:用模式匹配一个字符串所表达的抽象结果。二、先看一个简单的例子:需求:从字符串:{"_type":"FQDN","_oid":"51a867e4773da1128b1422ad"} 中取出这段数字:51a867e4773da1128b14
2015-12-18 10:51:33 13429
原创 Mysql插入数据错误:Duplicate entry '一份' for key 'term'
插入数据库语句:INSERT INTO tag(term) VALUES(?)错误提示 Duplicate entry '一份' for key 'term'原因是 term 设置了唯一性的索引,无法插入重复的term的值
2015-12-17 21:35:12 3311
原创 mysql 去除重复记录
去除term重复的记录:DELETE FROM tag WHERE id IN (SELECT id FROM (SELECT MAX(id) AS id,COUNT(term) AS COUNT FROM tag GROUP BY term HAVING COUNT >1 ORDER BY COUNT DESC) AS tab )
2015-12-17 16:44:44 786
原创 Mysql 常见错误代码: 1064
错误提示:错误代码: 1064You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'issplit = '1' where term = '00'' at line 1
2015-12-17 11:55:22 81630 3
原创 mysql遇到错误: "too many connections" 错误
当前操作系统 :windows10运行mysql版本:5.6.15出现错误的情况是:运行java多线程,需要频繁读写数据库错误提示:.......................Data source rejected establishment of connection, message from server: "Too many connections"
2015-12-16 18:14:26 1245
原创 奇葩的mysql问题
数据库启动成功之后,使用sqlyog 连接直接报错,mysql停止运行了,查看日志报错是这个:Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engin
2015-12-16 18:02:14 4029
Maven+Spring+Spring MVC+MyBatis+MySQL,搭建SSM框架环境
2015-01-21
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人