mysql - 限制 MySQL 重复

Question

我正在 MySQL 中运行以下查询

  REPEAT
    INSERT IGNORE INTO tableB
      SELECT a.column_name, a.level+1
      FROM tableA AS a
  UNTIL Row_Count() = 0 END REPEAT;

但我想对其进行限制，以便在 a.level 超过 10(或 Row_Count() = 0)时停止重复。我该怎么做？

Answer 1

  REPEAT
    INSERT IGNORE INTO tableB
      SELECT a.column_name, a.level+1
      FROM tableA AS a
      WHERE a.level <= 10
  UNTIL Row_Count() = 0 END REPEAT;

或者我不明白。