SELECT location_no, lot_batch_no, qty_onhand, qty_reserved, id, receipt_date, product_date, ......

inner join CREATE OR REPLACE VIEW M_INVENT_BARCODE_DIFF AS SELECT "INV_PART_NO","INV_ONHAND","INV_LOCATION","PART_NO","BAR_ONHAND","BAR_LOCATION" FROM ( SELECT m.part_no AS inv_...

PROCEDURE test IS comp_return_rec_ m_purchase_comp_return_tab%Rowtype; barcode_hist_rec_ m_barcode_inv_tran_hist_Tab%ROWTYPE; -- CURSOR get_comp_return IS SELEC......

show variables like 'innodb_status_output'; set GLOBAL innodb_status_output=ON; set GLOBAL innodb_status_output_locks=ON; select @@log_error; show VARIABLES like 'general%'; SHO...

要执行 0.146 秒左右,如果有 70 多个 ,就要 10秒钟; 改用表连接, 70 多个总共才需要 0.36秒

sql SELECT mt.* ,ds.ps_count FROM (select do.id, do.logistics_company_id, do.order_no, do.lable_info, do.ext_order_no, d......

添加maven 依赖 org.flywaydb flyway-core 5.0.3 org.flywaydb

正常全数据库备份语句 mysqldump -u admin -ppassword --databases db> C:\Users\Administrator\Desktop\db.dump 原因是视图里面有函数, 函数里面有存储过程, 存储过程有报错,报错是通过一张...

中午休息时, mysql mysql 对cpu 的使用率 162% , 整服务的cpu 使用率 41.5% 正常作业的时候 mysql 对cpu 的使用率 > 300% , 整服务的cpu 使用率 99% 所有的执行查询,都非常慢, 清除linux 服务...

SELECT C_NUM, CASE WHEN C_NUM - TRUNC(C_NUM) = 0 THEN '整数' ELSE '非整数' END FROM (SELECT 3.000 C_NUM FROM DUAL UNION ALL SELECT 3.100 FROM DUAL UNION ALL SELECT 4.400 FROM D...

-- Next Operation SELECT m.operation_no FROM Shop_Order_Operation_Tab m WHERE operation_no = ( SELECT MIN(s.operation_no) FROM Shop_Order_Operation_Tab s ......

-- 插入汇总行 INSERT INTO package_aging ( report_id, logistics_company_id, warehouse, date_applied, user_id, user_name, hour_00, hour_01, hour_02, hour_03, hour_04, hour_05, ho...

PROCEDURE Create_Pick_Task(info_ OUT VARCHAR2, move_no_ IN OUT VARCHAR2, order_no_ IN VARCHAR2, ......

如下面的遍历 CREATE DEFINER = 'root'@'localhost' PROCEDURE zita_wms.DeliveryOrderUtil_ConfirmByList( OUT confirmed_no_ INT, OUT not_confirmed_no_ ......

查看执行的sql 代码, 然后开启mysql 的 general_log set global general_log='on'; show variables like "%general_log%"; set global general_log='off'; 其中, 中间,在程序触发排序 SELECT...