set @var=1;if @var>1 then select * from client;elseselect * from otherTable;end if;这是我的mysql查询。你能指出为什么会出错吗？这真的让我筋疲力尽。2 S; K6 y& |5 T+ G- c
显示的错误是 3 n- f; v# h" |+ H6 v6 i# o' NIF @var >1 THEN SELECT *FROM client;MySQL said: Documentation#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'if @var>1 thenselect * from client' at line 1快速回答会很有帮助。3 \- o( H4 ]5 B" S6 m
' Z: Z' R* I& z. h; Z 解决方案:
技术问答
147 人阅读
|
0 人回复
|
2023-09-12
