SET @insert_data_query := CONCAT( 'insert into ', @table_name, '(id, crane_id, upload_time, weight, height, hz_jd, fudu, diff_w, diff_h, diff_hz, diff_fu, KK_num) select * from work_time where kk_num in (select kk_num from diff_work_count where diff_w_big_count = 1 and diff_work_count.diff_w_small_count >= 1 and diff_work_count.diff_h_no_count > 1 and diff_work_count.diff_hz_no_count > 1 and diff_work_count.diff_fu_no_count > 1);' );

这是一个MySQL的动态SQL语句，用于将一张表(work_time)中符合条件的数据插入另一张表(@table_name)中。插入数据的字段包括id、crane_id、upload_time、weight、height、hz_jd、fudu、diff_w、diff_h、diff_hz、diff_fu和KK_num。这些字段的值来源于work_time表中符合条件的数据行。条件是KK_num在另一张表(diff_work_count)中符合以下条件：diff_w_big_count等于1，diff_work_count.diff_w_small_count大于等于1，diff_work_count.diff_h_no_count大于1，diff_work_count.diff_hz_no_count大于1，diff_work_count.diff_fu_no_count大于1。

相关问题

SELECT ( SELECT group_concat(_ORG_ID) FROM ( SELECT @ORG_ID as _ORG_ID, ( SELECT @ORG_ID := PARENT_ID FROM t_sm_orginfo WHERE ORG_ID = @ORG_ID LIMIT 1 ) as t FROM t_sm_orginfo, (SELECT @ORG_ID := t1.ORG_ID ) t4 WHERE @ORG_ID is not NULL AND @ORG_ID != -1 ) t5 ,(SELECT t1.ORG_ID) t6 ) AS org_ids FROM t_sm_orginfo t1 WHERE t1.NODE_NAME LIKE '%公司%'; 这个sql在mysql5中执行报错Unknown table 't1' in field list，要怎么修复

出现 "Unknown table 't1' in field list" 的错误是因为查询的 SELECT 子句中引用了一个不存在的表 t1。

您可以尝试使用以下修复方法：

SELECT (
  SELECT group_concat(_ORG_ID)
  FROM (
    SELECT @ORG_ID as _ORG_ID, 
      ( SELECT @ORG_ID := PARENT_ID FROM t_sm_orginfo WHERE ORG_ID = _ORG_ID LIMIT 1 ) as t
    FROM t_sm_orginfo, (SELECT @ORG_ID := t1.ORG_ID ) t4
    WHERE @ORG_ID is not NULL AND @ORG_ID != -1
  ) t5 ,
  (SELECT t1.ORG_ID) t6
) AS org_ids
FROM t_sm_orginfo t1 
WHERE t1.NODE_NAME LIKE '%公司%';

在修复后，我将查询中的"t1"改为了"_"，因为查询中没有定义名为"t1"的表。如果这个修复方法不起作用，请提供更多的上下文或查询信息，以便我能更好地帮助您。

SET @batch_date = '20230222'; set @partition_name=concat('p',@batch_date); set @stat=concat('alter table tb_bond_price_comparision_reuslt truncate partition ',@partition_name); prepare stmt from @stat; execute stmt; set @stat=concat('alter table tb_trade_blotter_op_sec_liquidity_risk truncate partition ',@partition_name); prepare stmt from @stat; execute stmt; set @stat=concat('alter table tb_bond_price_comparision_trade_blotter_op_sec_mul truncate partition ',@partition_name); prepare stmt from @stat; execute stmt;转换为mybatis的xml文件中执行语句并生成spring boot的service层代码

1. 在mybatis的xml文件中添加以下语句：

<update id="truncatePartitions" parameterType="java.util.Map">
    SET @batch_date = #{batchDate};
    set @partition_name=concat('p',@batch_date);
    set @stat=concat('alter table tb_bond_price_comparision_reuslt truncate partition ',@partition_name);
    prepare stmt from @stat;
    execute stmt;
    set @stat=concat('alter table tb_trade_blotter_op_sec_liquidity_risk truncate partition ',@partition_name);
    prepare stmt from @stat;
    execute stmt;
    set @stat=concat('alter table tb_bond_price_comparision_trade_blotter_op_sec_mul truncate partition ',@partition_name);
    prepare stmt from @stat;
    execute stmt;
</update>

2. 在spring boot的service层代码中，添加以下方法：

@Autowired
private SqlSessionTemplate sqlSessionTemplate;

public void truncatePartitions(String batchDate) {
    Map<String, Object> paramMap = new HashMap<>();
    paramMap.put("batchDate", batchDate);
    sqlSessionTemplate.update("truncatePartitions", paramMap);
}

3. 调用truncatePartitions方法，即可执行相关的truncate partition语句。例如：

truncatePartitions("20230222");