此存储过程中有什么错误 [英] whats error in this store procedure

问题描述

DELIMITER $$

DROP PROCEDURE IF EXISTS `datepaty`.`datepart` $$
CREATE PROCEDURE `datepaty`.`datepart` ()
BEGIN
 declare week1 int
 SELECT week('98-04-01');
END $$

DELIMITER ;

我收到以下错误

i get the following error

Script line: 4  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 'SELECT week('98-04-01');
END' at line 4

行 在此先谢谢您

thank you in advance

推荐答案

DROP 过程 IF EXISTS `datepaty`.`datepart`

DROP PROCEDURE IF EXISTS `datepaty`.`datepart`

创建 过程`datepaty`.`datepart`() 开始 声明 week1 int 选择周(' 98-04-01' span>); END

CREATE PROCEDURE `datepaty`.`datepart` () BEGIN declare week1 int SELECT week('98-04-01'); END

DELIMITER;

DELIMITER ;

我收到以下错误

i get the following error

Script line: 4  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 'SELECT week('98-04-01');
END' at line 4

行 预先谢谢你

thank you in advance

这篇关于此存储过程中有什么错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！