| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I am receiving an error (error code) on a stored procedure. It's frekin me out as its working on one place but giving error on the other. The sequence that I will follow explaining my problem below will consist of Version, Error code and description, Error code received string and No error code string.... Hope this gives a clear explanation of the problem that I am facing...hoping for swift reply Thanks, SJ
---------------------------------------------------------------------------------- MYSQL VERSIONS Mysql Administrator interface 1.2.15 Mysql Server 5.1.30 community via TCP/IP Mysql client version 5.1.11 Navcat lite 8.2.13 ---------------------------------------------------------------------------------- ERROR CODE AND DESCRIPTION ERROR CODE: 1064 ERROR DESCRIPTION: 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 'END' at line 4 ---------------------------------------------------------------------------------- ERROR RECEIVED DELIMITER $$ DROP PROCEDURE IF EXISTS `familytree`.`UserInfo_insert` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `UserInfo_insert`( IN UserLogin VARCHAR(50),UserPassword Varchar(50),UserEmailId varchar(50),UserFirstName varchar(50),UserLastName varchar(50),UserFatherName varchar(50),UserMotherName varchar(50)) BEGIN insert into UserInfo(UserId,Password,EmailId,FirstName,LastNam e,FatherName,MotherName) values (UserLogin,UserPassword,UserEmailId,UserFirstName, UserLastName,UserFatherName,UserMotherName) END $$ DELIMITER ; ---------------------------------------------------- NO ERROR RECEIVED DELIMITER $$ DROP PROCEDURE IF EXISTS `familytree`.`UserInfo_get` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `UserInfo_get`( IN UserLogin VARCHAR(50),UserPassword Varchar(50)) BEGIN select concat(firstname,' ',lastname) as name from userinfo where userid=UserLogin and Password=UserPassword; END $$ DELIMITER ; ---------------------------------------------------------------------------------- |
![]() |
| Viewing: Tutorialized Forums > Databases > MySQL > Mysql_Stored Procedure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|