The CREATE function tabcmessalot (@ title varchar (10))
Returns the @ ctable table (title varchar (10) null, des varchar (100) null)
As
The Begin
Insert the @ ctable Select title, des the from the product WHERE the title LIKE '%' + '%' + @ the title
Return
End

I want to build a table function, online to find this code but not through operation, is under the MYSQL does not support table-valued functions or my version is too low, as soon as I run I said grammar errors,

CodePudding user response:

This code is SQL Server, you can try this code on your run the SQL Server database;
The current MySQL function does not support return a set of records;
Can try to use stored procedures to achieve,