I am trying to create a MySQL function using phpMyAdmin and getting this error. #1415 - Not allowed to return a result set from a function The function code is as below: DELIMITER $$ CREATE FUN...

How can I see the list of the stored procedures or stored functions in mysql command line like SHOW TABLES; or SHOW DATABASES; commands.

I am working with existing project, and I am found a sql query with sql-function like SELECT * FROM money WHERE amount = float_convert(0.1); This Query is Working Properly, But I want to see and e...

I am trying to create a function in MySQL: Here is the SQL code: CREATE FUNCTION F_Dist3D (x1 decimal, y1 decimal) RETURNS decimal DETERMINISTIC BEGIN DECLARE dist decimal; SET dist = SQRT(x1 -...

DELIMITER // CREATE FUNCTION fnc_credit_custstatus RETURNS VARCHAR(6) DETERMINISTIC BEGIN DECLARE custstatus VARCHAR(6); IF CustCredit>='1000',THEN SET custstatus='VIP'; ELSEIF CustCredit...

I have browsed around and other solutions don't seem to be working for me here. I keep getting a 'No return found for function' error when trying to create this function in MySQL. Any idea why? CRE...

I got confused with a seemingly simple concept. MySQL defines deterministic function as a function that: always produces the same result for the same input parameters So in my understanding, func...

While importing the database in mysql, I have got following error: 1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logg...

What will be the best way to include the result with dollar sign? I was using something like CONCAT('£', SUM(Deposits)) AS TotalDeposits but it seems not working.