logo
publist
写文章

简介

该用户还未填写简介

擅长的技术栈

可提供的服务

暂无可提供的服务

mysql 根据值显示不同内容 case when 多个条件

mysql 根据值显示不同内容场景:我们在数据库中经常以int存储状态值,使用sql查询的时候不希望输出的是数字而是对应的字符串SELECTCASE WHEN STATUS='1' THEN '状态1'WHEN STATUS='2' THEN '状态2'WHEN STATUS='3' THEN '状态3'ELSE '状态5' END AS '状态'FROM table;.........

#mysql
解决mysql报错this is incompatible with DISTINCT

解决mysql报错this is incompatible with DISTINCT

文章图片
#mysql#数据库
js获取audio语音时长

js获取audio语音时长//获取audio语音时长function getVoiceTime() {$('ul.conversation li .outer-right audio.addVoiceTime').each(function () {var audio = $(this)[0], duration;audio.load();audio.oncanplay = function(){

#javascript#前端#语音识别
解决 Install fail! Error: ENOTSUP: operation not supported on socket, symlink

解决 Install fail! Error: ENOTSUP: operation not supported on socket, symlink

#vue.js#前端#javascript
解决secureCRT连接Key exchange failed. No compatible key exchange method问题

环境win 10secureCRT 8SecureCRT 连接ubunto问题Key exchange failed.No compatible key exchange method. The server supports these methods: curve25519-sha256,curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-

电脑蓝屏后,idea运行springboot报 java.lang.IndexOutOfBoundsException: Range [-1, -1 + 1025) out of bounds

电脑蓝屏后,跑springboot项目报:Module 'hst-services' production: java.lang.IndexOutOfBoundsException: Range [-1, -1 + 1025) out of bounds for length 1024

文章图片
#java#开发语言
解决Unrecognized option: --add-opens=java.base/java.lang=ALL-UNNAMED问题

解决Unrecognized option: --add-opens=java.base/java.lang=ALL-UNNAMED问题

文章图片
#java#开发语言
idea设置自动编译spring boot代码,idea代码修改后无须重启服务立即生效

idea设置自动编译spring boot代码,idea代码修改后无须重启服务立即生效

文章图片
#intellij-idea#spring boot#java
windows解决error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27

windows解决error: Microsoft Visual C++ 9.0 is required. Get it from http://aka.ms/vcpython27环境报错解决方案环境windows 10 64位python2.7.18报错pip install support安装support报错Complete output (9 lines):running installr

#python
解决error: storage size of ‘ctx‘ isn‘t known

问题In file included from D:\site\c\sm2_gityf\sm2.c:17:D:\site\c\sm2_gityf\kdf.h: In function 'x9_63_kdf':D:\site\c\sm2_gityf\kdf.h:12:13: error: storage size of 'ctx' isn't known原因openssl函数由于版本不同的问题,已经

    共 48 条
  • 1
  • 2
  • 3
  • 4
  • 5
  • 请选择