如何在mysql Server版本中创建程序：5.0.77 [英] How to create procedure in mysql Server version: 5.0.77

问题描述

大家好，



我在phpmyadmin中使用MySql Server Veersion：5.0.77

我的过程语法就像是

Hi all,

I am using the MySql Server Veersion: 5.0.77 in phpmyadmin
my procedure syntax is like

CREATE  PROCEDURE `SP_GET_ALLJOBIDS`()
BEGIN
       select * from jobdetails  ;
END

但点击go按钮后显示错误就像



SQL查询：文档



CREATE PROCEDURE`SP_GET_ALLJOBIDS`（）BEGIN SELECT *

来自jobdetails;



MySQL说：文档

＃1064 - 你的SQL语法有错误;查看与你的MySQL服务器版本对应的手册，以便在第3行''''附近使用正确的语法



如何解决错误，请帮帮我。 。



谢谢

but after click on go button show the error is like

SQL query: Documentation

CREATE PROCEDURE `SP_GET_ALLJOBIDS` ( ) BEGIN SELECT *
FROM jobdetails;

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 '''' at line 3

how to solve the error, please help me..

thanks

推荐答案

http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx [ ^ ]



别忘了分隔符！

http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx[^]

Don''t forget the delimiter!

DELIMITER //
CREATE PROCEDURE SP_GET_ALLJOBIDS()
  BEGIN
  select * from jobdetails;
  END //
DELIMITER ;

这篇关于如何在mysql Server版本中创建程序：5.0.77的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！