![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
猫墨*
路虽远 行则将至
展开
-
【mysql】自定义split函数
【mysql】自定义split函数,达到按字符分割字符串为数组的目的。原创 2023-06-21 10:56:54 · 562 阅读 · 0 评论 -
mysql的mediumtext类型字段在java如何获取
数据库:PO:重点是autoResultMap = true和@TableField(typeHandler = FastjsonTypeHandler.class)@Data@EqualsAndHashCode(callSuper = false)@TableName(value = "xxx", autoResultMap = true)@ApiModel("一分钱充值用户配置表")public class xxx implements Serializable {@Tabl原创 2021-12-22 16:41:19 · 2128 阅读 · 0 评论 -
mysql索引-int类型查询时使用引号括住是否走索引
-- explain select * from student where name ="88";-- explain select * from student where name ='88';-- explain select * from student where name =88;-- 当查询条件是字符串时,不管单引号双引号都走索引,但是不加引号 隐式转换不走索引-- explain select * from student where abs(age) =18;-- exp..原创 2021-12-02 14:31:33 · 1585 阅读 · 2 评论