Arry_Coding的博客

1、首先：要知道你的账户2.打开可以连接的navicat，在查询语句页面，输入以下操作，就可以修改成功密码了

select a.order_sn,a.is_delete from nur_pro_trade.ns_order_service_deduct a left join ptcs_pro_extended.ns_attendant_service_record b on a.order_sn=b.order_sn where (a.service_start_date >=DATE_FORMAT(CURDATE(),'%Y-%m-%d %H:%i:%s') and a.service_start_d

1.eg:如果orderStatus传入0查出的结果是sql不会拼接2.解决办法：1.把orderStatus!=’'条件去掉

SELECT sum(if(a.state=?,a.pay_amount,0)) issued_amount, count(IF(a.state =1, 1, NULL)) success_count, count(IF(a.state =4 or a.state=2, 1, NULL)) failed_countFROM ns_wage_payment_detail aINNER J...

1.使用not in语句查询效率太低，可以使用下面的方式进行优化优化前：SELECT sum(a.salary) as nursingCount,b.account_no, FROM ns_order_service_record a INNER JOIN ptcs_extended.ns_nursing_workers b ON a.nursing_id = b.nursing_id ...

1.声明游标之前不能使用红框内语句，否则会报错

select GROUP_CONCAT(column_name)from information_schema.COLUMNS where table_name= 'ns_scheduling_shift'//改一下表名即可

[https://www.cnblogs.com/yhtboke/p/9467763.html]

1.Between 86 and 91: 包括边界值2.Order by sno desc:根据某个字段排序3.Count：计算有多少条记录，一般和group by一起用4.以Cno升序、Degree降序查询Score表的所有记录。在cno相等的情况下按degree降序5.limit用法：limit 3:表示最多返回三行数据 与limit:0,3等价6.Limit 95,-1:表示从...

CREATE TABLE IF NOT EXISTS new_table_bak (LIKE old_table);INSERT INTO new_table_bak SELECT * FROM old_table;2.Create table new_table_name (Select * from old_table_name);