CORE TERMINAL
WEB BOT HELP & OLD BOY : 웹 봇 & 올드보이 도움말
마리아 디비 이벤트 스케쥴러 : 바이빕트 API 실시간 데몬 수집 복사
DATE: 2026-03-05 20:23
* 마리아 디비 이벤트 스케쥴러 : 바이빕트 API 실시간 데몬 수집 복사
1. 컬럼 문제 발생으로 어려움을 격었다.
- 첨부파일 참조
1. 컬럼 문제 발생으로 어려움을 격었다.
- 첨부파일 참조
PDF VIEWER : MariaDB 이벤트 복사 트러블슈팅 정리.pdf
EXTRA CODE SNIPPET
INSERT INTO daemon_bybit_coin_24h (
symbol, korean_name, `time`,
status, baseCoin, quoteCoin, settleCoin, optionsType,
launchTime, priceScale,
minLeverage, maxLeverage, leverageStep,
minPrice, maxPrice, tickSize,
maxOrderQty, minOrderQty, qtyStep, postOnlyMaxOrderQty,
unifiedMarginTrade, fundingInterval, copyTrading,
upperLimitPrice, lowerLimitPrice,
lastPrice, indexPrice, markPrice,
prevPrice24h, price24hPcnt, highPrice24h, lowPrice24h, prevPrice1h,
openInterest, openInterestValue,
turnover24h, volume24h,
fundingRate, nextFundingTime,
ask1Size, bid1Price, ask1Price, bid1Size,
execId, price, size, side, isAdlTrade, mPnL, isBlockTrade,
start, `open`, high, low, `close`, volume, turnover,
m_close, i_close, p_close,
buyRatio, sellRatio, period,
riskId, isLowestRisk, maintenanceMargin, initialMargin, `limit`
)
SELECT
symbol, korean_name,
UNIX_TIMESTAMP(NOW(3))*1000,
status, baseCoin, quoteCoin, settleCoin, optionsType,
launchTime, priceScale,
minLeverage, maxLeverage, leverageStep,
minPrice, maxPrice, tickSize,
maxOrderQty, minOrderQty, qtyStep, postOnlyMaxOrderQty,
unifiedMarginTrade, fundingInterval, copyTrading,
upperLimitPrice, lowerLimitPrice,
lastPrice, indexPrice, markPrice,
prevPrice24h, price24hPcnt, highPrice24h, lowPrice24h, prevPrice1h,
openInterest, openInterestValue,
turnover24h, volume24h,
fundingRate, nextFundingTime,
ask1Size, bid1Price, ask1Price, bid1Size,
execId, price, size, side, isAdlTrade,
NULLIF(mPnL, ''),
isBlockTrade,
start, `open`, high, low, `close`, volume, turnover,
m_close, i_close, p_close,
buyRatio, sellRatio, period,
riskId, isLowestRisk, maintenanceMargin, initialMargin, `limit`
FROM daemon_bybit_Ticker