當前位置:編程學習大全網 - 腳本源碼 - 幫忙調試壹段MYSQL的存儲過程!

幫忙調試壹段MYSQL的存儲過程!

=====================================

/*腳本2開始*/

DECLARE RANDSTR varchar(2) DEFAULT CAST(round(rand()*53) AS char(2));

DECLARE LocationId INT DEFAULT (SELECT `ID` FROM `shuo_Citys` WHERE `PID`>0 ORDER BY rand() Limit 1);

DECLARE Location VARCHAR(50) DEFAULT (SELECT `Name` FROM `shuo_Citys` WHERE `ID`=LocationId);

/*腳本2結束*/

=====================================

這段移到

declare Uid int;

的下壹行

原因:declare 必須都在最前面

  • 上一篇:泰劇天使之爭的女主角還演過哪些?
  • 下一篇:Clock photo potato哪個發音不同?
  • copyright 2024編程學習大全網