摘要:
``` SET @sum := 0; SELECT *, (@sum := @sum + flow) AS cumulative_sum FROM wrs_brwater_avg_gq WHERE mea_date > '2023-04-15' ORDER BY mea_date; ``` myba 阅读全文
摘要:
5.6版本 SET PASSWORD FOR 'root'@'%' = PASSWORD('123456'); FLUSH PRIVILEGES; 5.7版本 update user set authentication_string = password('123456') where user= 阅读全文
摘要:
SELECT date_format( date_add( '2023-03-01', INTERVAL ( id - 1 ) DAY ), '%Y-%m-%d' ) date FROM sys_api_info WHERE id <= DAY (last_day( '2023-03-01' )) 阅读全文
摘要:
package org.jeecg.config.mybatis.interceptor; import java.math.BigDecimal; public class GeoPoint { public GeoPoint(BigDecimal lng, BigDecimal lat) { t 阅读全文