[执行语句1]: SELECT @i:=@i+1 AS sequence_num, CAST(@i AS SIGNED) AS signed_num FROM classify_code, (SELECT @i:=0) t; 执行失败(语句1) -2007: 第 1 行, 第 8 列[@]附近出现错误: 语法分析出错
时间: 2023-12-10 09:37:49 浏览: 243
这个 SQL 语句有错误。可以尝试改成以下语句:
```
SELECT @rownum:=@rownum+1 AS sequence_num, CAST(@rownum AS SIGNED) AS signed_num
FROM classify_code, (SELECT @rownum:=0) r
```
这样应该可以正确执行,并且生成一个包含序号和有符号整数的结果集。
阅读全文
相关推荐












