摘要：-- mysql 截取 -- left(str, length) 截取左边 select left('sqlstudy.com', 3); -- sql select left('sqlstudy.com', 8); -- sqlstudy -- 字符串截取：right(str, length) s 阅读全文

摘要：-- mysql 截取 -- left(str, length) 截取左边 select left('sqlstudy.com', 3); -- sql select left('sqlstudy.com', 8); -- sqlstudy -- 字符串截取：right(str, length) s 阅读全文

摘要：select -- REPLACE(CONCAT(t.sw,t.shi,t.gw),'零','') as periods REPLACE(CONCAT(t.sw, bai,t.gw, t.shi,gw1),'零','') as periods , shi from (select CASE WHEN 阅读全文

摘要：UPDATE `tenant_task_config` SET `params` = replace(`params`,'"periods_end": "10"','"periods_end": "15"') WHERE `key_id` in (3523,3560); ///替换 tenant_t 阅读全文

摘要：SELECT T.uuid, T.obj_uuidFROM AR_APPROVE_HUMAN_ENTRY TINNER JOIN ar_document T1 ON T.obj_uuid = T1.uuidINNER JOIN ( SELECT a.node_code FROM ar_documen 阅读全文

摘要：SELECT case WHEN (LOCATE('nocheck', d.VALUE) > 0 && FORMAT(SUM(G.total_amount2023), 2) is NOT null) || (d.VALUE = '' && (FORMAT(SUM(G.total_amount2023 阅读全文

摘要：SELECT case when a.value is null || a.`value` = '' || LOCATE('nocheck', a.VALUE) > 0 then '' ELSE a.value end as bgy_contract_project , case when c.va 阅读全文

摘要：SELECT b.uuid AS document_id, b.file_name, a.need_num, a.valid_num, d.scanning_file_id, d.scanning_flag, d.receive_num, d.come_from, d.from_person, d. 阅读全文

摘要：SELECT case WHEN LOCATE('nocheck', t.A) > 0 && t.A is null || t.A = '' THEN t.op ELSE t.A END AS total , t.op, t.A FROM ( SELECT a.value as A , c.valu 阅读全文

摘要：AND (replace(replace(b.grantor_pledgor_name,'(','（'),')','）') like ? or replace(replace(b.grantor_pledgor_name,'（','('),'）',')') like ?) 解决 全角半角问题 可直接 阅读全文

摘要：SELECT sum(c.account_receivable) - IF(SUM(c.suppliers_money) is null,0,SUM(c.suppliers_money)) AS income_moneyFROM biz_asset_sec_info a, biz_asset_sec 阅读全文

摘要：SELECT uuid, fund_no, company_name, proj_company_name, regional_company, factor_amt, IF ( is_export_flag = 0, '未导出', '已导出' ) AS is_export_flag FROM biz_lh_payment_info a WHERE sys_status ... 阅读全文

摘要：String StrSql = " SELECT " + " CASE WHEN b.ACTIVITY_NAME = '非常规价格申请' THEN '申请中' " + " WHEN b.ACTIVITY_NAME = '资金部价格审批' THEN '金融副总监审批中' " + " WHEN b.AC 阅读全文

摘要：order by 和 group by 的区别order by 和 group by 的区别：1，order by 从英文里理解就是行的排序方式，默认的为升序。 order by 后面必须列出排序的字段名，可以是多个字段名。2，group by 从英文里理解就是分组。必须有“聚合函数”来配合才能使用 阅读全文

摘要：ALTER TABLE biz_lc_payment_info ADD COLUMN export_time datetime DEFAULT NULL COMMENT '导出时间' AFTER is_export_flag ; 阅读全文

摘要：SELECT a.uuid, a.pay_id, b.core_enterprise_name, a.financial_institutions_id, c.financial_institutions_name, d.sign_body_name, a.periods, e.suppliers_name, a.suppl... 阅读全文

摘要：SELECT a.uuid,a.pay_id, CONCAT( '付款确认书编号:', a.pay_id, ' ', d.item_company_name, ... 阅读全文

摘要：BEGIN DECLARE postUuid VARCHAR(40); DECLARE post VARCHAR(40); SELECT t2.user_id INTO postUuid FROM ( SELECT IF(e.post_user_id IS NULL, d.us... 阅读全文

摘要：Windows服务 -- 启动MySQL net start mysql -- 创建Windows服务 sc create mysql binPath= mysqld_bin_path(注意：等号与值之间有空格) 连接与断开服务器 mysql -h 地址 -P 端口 -u 用户名 -p 密码 SHOW PROCESSLIST -- 显示哪些线程正在运行 SHOW VARIAB... 阅读全文

摘要：本文导语: mysql中字符串和时间互相转换的方法(自动转换及DATE_FORMAT函数)一、mysql中字符串转换成日期下面将讲述如何在MYSQL中把一个字符串转换成日期：1、无需转换的：SELECT * FROM tairlist_day WHERE rq>'2010-07-31' AND rq 阅读全文