Community discussion forum

MYSQL6 USER DEFINED FUNCTION

• • Reply

  1 year ago

  by cnu1251

  cnu1251

  , India

  Joined 2 years ago

  Hai Friends

  how to write tabel data retreval usder defined functions in mysql6

  ie an example shown below ie in sql server

   CREATE FUNCTION getname(@ID int)

   RETURNS varchar (50) AS

   BEGIN Declare @V1 Varchar(50)

   select @v1=itemname from subitemmaster where itemid = @id

   return @V1

  END

  This is in SQL Server How this like function write in mysql 6 any one know about this please help me Thanks in advance

  Report abuse