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"的表。如果这个修复方法不起作用，请提供更多的上下文或查询信息，以便我能更好地帮助您。

相关问题

在mybatis中该sql语句有什么错误<select id="selectJourneyTempDetailListById" resultMap="JourneyTempDetailDtoResult"> select temp_day, GROUP_CONCAT(activity_id) activity_id, GROUP_CONCAT(address_type_cd) address_type_cd, GROUP_CONCAT(activity_type_cd) activity_type_cd, GROUP_CONCAT(presenter_type_cd) presenter_type_cd, from journey_temp_detail where temp_id = #{id} and is_del = '0' group by temp_day </select>

这个 SQL 语句中的错误是缺少了 `SELECT` 关键字。在 `from` 关键字前面应该加上需要查询的列名，比如 `SELECT temp_day, GROUP_CONCAT(activity_id) activity_id, ...`。修改后的 SQL 语句如下：

<select id="selectJourneyTempDetailListById" resultMap="JourneyTempDetailDtoResult">
  SELECT
    temp_day,
    GROUP_CONCAT(activity_id) activity_id,
    GROUP_CONCAT(address_type_cd) address_type_cd,
    GROUP_CONCAT(activity_type_cd) activity_type_cd,
    GROUP_CONCAT(presenter_type_cd) presenter_type_cd
  FROM journey_temp_detail
  WHERE temp_id = #{id} AND is_del = '0'
  GROUP BY temp_day
</select>

注意，在 `WHERE` 子句中使用的参数 `id` 应该在 Java 代码中传入。

UPDATE data_catalog_dept_group_statistics_temp t, ( SELECT c.cata_group_id AS group_id, count( 1 ) AS cata_amount FROM data_catalog c WHERE is_del = 0 AND cata_group_id LIKE CONCAT('3071140224','%') GROUP BY c.cata_group_id ）tmp set t.base_cata_amount = tmp.cata_amount where t.group_id = tmp.group_id; 语法哪里有问题

这段 SQL 语句的语法是有问题的，问题在于子查询的 SELECT 子句中，GROUP BY 子句最后缺少了一个空格。正确的写法应该是：

UPDATE 
    data_catalog_dept_group_statistics_temp t,  
    ( 
        SELECT 
            c.cata_group_id AS group_id,  
            count(1) AS cata_amount  
        FROM 
            data_catalog c 
        WHERE 
            is_del = 0 AND 
            cata_group_id LIKE CONCAT('3071140224', '%') 
        GROUP BY 
            c.cata_group_id
    ) tmp 
SET 
    t.base_cata_amount = tmp.cata_amount 
WHERE 
    t.group_id = tmp.group_id;

在子查询中，GROUP BY 子句最后的 AS 子句之后需要加一个空格，否则会被认为是一个新的字段，导致语法错误。