2025年mysql报错1172该怎样解决_MySQL错误1172-结果包含多个行

科技前沿 • 2025-01-11 14:27 • 阅读 41

大家好，我是讯享网，很高兴认识大家。

I'm getting this error from MySQL when running a query inside a stored procedure:

Error Code: 1172

Result consisted of more than one row

I understand the error: I'm doing a SELECT (...) INTO (var list), and thus the query is required to return a single row. When I use LIMIT 1 or SELECT DISTINCT, the error goes away.

However: when I run the original query manually (without LIMIT or DISTINCT), it does return a single row. So I'm suspecting I may have bumped into a MySQL bug. Does anyone know what could be happening?

EDIT

I'm posting the SQL as requested. Everything that starts with an underscore is a variable declared earlier inside the procedure. When I test it, I'm replacing _cd_pai_vc with the ID for the record that is causing the problem.

SELECT a.valor, IFNULL(p.valor, 0), fn_cd2alias(ra.cd_registro), fn_cd2alias(IFNULL(p.valor,0))

INTO _valor, _cd_pai_vc, _alias_verbete, _alias_pai

FROM dados_registros ra

INNER JOIN dados_varchar255 a

ON a.cd_registro = ra.cd_registro

AND a.fl_excluido = 0

AND a.alias = 'vc-verbetes-termo'

LEFT OUTER JOIN dados_registros rp

INNER JOIN dados_int p

ON p.cd_registro = rp.cd_registro

AND p.fl_excluido = 0

AND p.alias = 'vc-remissoes-termo referenciado'

INNER JOIN dados_int pt

ON pt.cd_registro = rp.cd_registro

AND pt.fl_excluido = 0

AND pt.alias = 'vc-remissoes-tipo remissao'

AND fn_cd2alias(pt.valor) = 'hierarquica'

ON ra.cd_registro = rp.cd_entidade

AND rp.fl_excluido = 0

AND fn_cd2alias(rp.cd_modulo) = 'vc-remissoes'

WHERE ra.cd_registro = _cd_pai_vc

AND ra.fl_excluido = 0;

解决方案

I had the similiar issue and when I put table alias it worked like a charm.

SELECT t.tax_amount,t.tax_percentage FROM nepse_tax t

2025年mysql报错1172该怎样解决_MySQL错误1172-结果包含多个行

相关推荐