31.03.2022 akışı
Mysql bulk insert Link Mysql query starts with Link Mysql find duplicate records Link SELECT t . Login , t . Symbol , t . TotalOrderCount , t . TotalVolume , t . CMD , CASE t . CMD WHEN 0 THEN 'SELL' ELSE 'BUY' END AS OrderType FROM ( SELECT T_ORDER1 . LOGIN AS Login , T_ORDER1 . SYMBOL AS Symbol , COUNT ( T_ORDER1 . CMD ) AS TotalOrderCount , SUM ( T_ORDER1 . VOLUME ) AS TotalVolume , T_ORDER1 . CMD AS CMD FROM MT4_TRADES AS T_ORDER1 WHERE T_ORDER1 . LOGIN IN ( SELECT LOGIN FROM MT4_USERS WHERE LOGIN > 10001 AND BALANCE != EQUITY ) AND T_ORDER1 . CLOSE_TIME = '1970-01-01 00:00:00' AND ( T_ORDER1 . CMD = 0 ) AND T_ORD