我是MySQL的新手,我在下面写了一个简单的查询:
CREATE Table tblFeedBack
(
`FeedBackID` INT AUTO_IncremeNT,
`UserID` INT,
`Inserted_TS` TIMESTAMP ,
`FeedBackValue` VARCHAR(100),
PRIMARY KEY (FeedBackID)
);
CREATE PROCEDURE tblFeedBack_InsertUpdate
(
IN U_ID INT,
IN FB_Value VARCHAR(50)
)
BEGIN
IF ((Select COUNT(*) From 'tblFeedback') < 3)
BEGIN
INSERT INTO 'tblFeedBack' (`UserID`,`FeedBackValue`)
VALUES (U_ID,FB_Value);
END
ELSE
BEGIN
DECLARE @MostRecentFID INT;
SELECT TOP 1 `FeedBackID` FROM tblFeedback
WHERE UID = U_ID
ORDER BY `Inserted_TS` DESC
INTO @MostRecentFID;
UPDATE tblfeedback
SET `FeedBackValue` = @FeedBackValue
WHERE `FeedBackID` = @MostRecentFID
END
END
我收到此错误:
Schema Creation Failed: 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 ''tblFeedBack' (`UserID`,`FeedBackValue`) VALUES (1,'12')' at line 9
谁能帮我解决这个问题?提前致谢。
MySQL不支持 TOP
您LIMIT 1
按顺序使用它们。
Select `FeedBackID` FROM tblFeedback
WHERE UID = U_ID
ORDER BY `Inserted_TS` DESC
LIMIT 1
INTO @MostRecentFID;
同样,当您使用引号查询表时,它也区分大小写。
IF ((Select COUNT(*) From 'tblFeedback') < 3)
应该
IF ((Select COUNT(*) From 'tblFeedBack') < 3)
修复这2个错误,它应该可以工作。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句