Tag Info

New answers tagged

0

Use this CREATE FUNCTION the_nxt (in_number VARCHAR(10)) RETURNS varchar(10) BEGIN if (exists(select tel_number from nxt_records where tel_number='in_number' )) then return 'true'; else return 'false'; end if; END$$ Faced this error ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary ...


1

I found the error to have been my varchar CREATE FUNCTION the_nxt (in_number VARCHAR(255)) RETURNS varchar which i changed to CREATE FUNCTION the_nxt (in_number VARCHAR(255)) RETURNS varchar(255) and worked.



Top 50 recent answers are included