Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

MySQL stored function problem

⇧
0
⇩
41 views

I'm creating a stored function like this

CREATE FUNCTION getVendorID(IN venname VARCHAR(255)) 
RETURNS INT
BEGIN
    DECLARE a INT;
    SELECT vendorid FROM vendors WHERE vendorname LIKE venname INTO a;
    RETURN a;
END$$

but I receive an error:

ERROR 1064 (42000): 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 'IN venname VARCHAR(255))
RETURNS INT
BEGIN
        DECLARE a INT;
        SELECT vendorid FRO' at line 1
mysql function create
asked June 15, 2011 5:19 pm CDT
dzd
posted via StackOverflow

1 Answer

⇧
0
⇩
 

MySQL functions only takes IN-parameters, and therefor they cannot be declared as IN.

DELIMITER $$
CREATE FUNCTION getVendorID(venname VARCHAR(255)) 
RETURNS INT
BEGIN
    DECLARE a INT;
    SELECT vendorid FROM vendors WHERE vendorname LIKE venname INTO a;
    RETURN a;
END$$
DELIMITER ;
answered June 15, 2011 5:23 pm CDT
Björn

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Problem with PostgreSQL function parameters (Converting MySQL Stored Procedures)
January 4, 2011
MySQL 5: Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure
January 4, 2011
PostgreSQL/PostGIS stored function + Eclipselink converter problem
February 8, 2011
Trying to convert simple execution stored procedure to postgres function - can't get CURRVAL('table_seq') to function
January 7, 2011
Mysql stored function help needed
May 6, 2011
Mysql stored function help needed
May 6, 2011
MySQL if statement sequence in stored function
April 26, 2011
[MySQL] How to check if INSERT went well in stored function?
May 9, 2011
MySQL Stored Function to create a slug
March 23, 2011
Changing ORDER BY in a MYSQL Stored Procedure / Function
January 18, 2011
Getting MySQL error when executing a function / stored procedure
January 19, 2011
Fatal Error while calling MySQL stored function from PHP using MySQLi
March 12, 2011
Converting MySQL Stored Procedures to PostgreSQL function. What do I do with these replace() calls?
January 10, 2011
Call and get return value from stored mysql function using a mysql prepared command by c#
March 15, 2011
PHP PDO and Stored Function
January 14, 2011
How to read a UDT from a postgres stored function
January 10, 2011
Postgres function or stored procedure that outputs multiple columns?
March 28, 2011
Problem with mysql (LIKE function)
June 11, 2011
Mysql function problem
May 26, 2011
Problem with MYSQL function and GROUP_CONCAT
March 22, 2011
Problem with my first MySQL Function. Getting one error after the other.
April 23, 2011
(drop downs, Php and Mysql) problem with stored value in Mysql
June 8, 2011
Problem when selecting MySQL stored procedure to populate datatable in Visual Studio
February 23, 2011
MySQL problem using CREATE FUNCTION in cPanel
May 10, 2011
Problem with MySQL LEAST() function not returning results
February 16, 2011
Problem with fetching results from mysql via php function
May 11, 2011
Problem with function variables and php (drop downs with MySQL)
June 3, 2011
Problem in adding two outputs from mysql function inside another funtion
January 13, 2011
PHP Problem with MySQL query. While is running the function only for the first mysql result.
May 3, 2011
Where exactly the table-data stored using MySQL-cluster gets stored ?
January 28, 2011