TRUNCATE TABLE aijieyun1

CREATE INDEX idx_charge_time ON aijieyun1(chargeStartTime, chargeEndTime);  --联合索引创建



SELECT * 
FROM aijieyun1 
WHERE DATE(bs) = '2026-01-27';   



-- 更新2026年1月27日00:00:00 至 23:59:59的所有数据
UPDATE aijieyun1
SET bs = '20260127PICI3'
WHERE import_time >= '2026-01-27 17:26:00' 
  AND import_time <= '2026-01-27 17:37:59';

SELECT * from aijieyun1 where bs='20260127PICI3' --主要语句


SELECT 
  offerName AS '商品名称',
  resourceId AS '资源ID',
  offerSpec AS '商品规格',
  idcName AS '数据中心名称',
  chargeName AS '计费项',
  chargeUnitName AS '计费单位',
  settleValue AS '计费量',
  billingDuration AS '计费时长',  -- 注意：原字段名若含空格需用反引号包裹，如 `billing Duration`
  rateCycleName AS '计费周期',
  chargeStartTime AS '计费开始时间',
  chargeEndTime AS '计费结束时间',
  agreementCode AS '合同编号',
  customName AS '客户名称'
FROM aijieyun1 
WHERE bs = '20260127PICI3';