jafm Posted March 31, 2017 at 03:27 PM Report #603449 Posted March 31, 2017 at 03:27 PM Boas, podem pff ajudar na sintaxe da linguagem do mysql. Em SQL server usaria este formato para devolver um campo da query. Em mysql está a dar erro. Podem ajudar-me. CREATE FUNCTION `sv2`.`fn_Linha` ( datas datetime ) RETURN varchar(60) BEGIN declare linhaX varchar(60) SELECT linhasX=workName FROM total WHERE rName='XXX' and type='1' AND Date = datas ORDER BY reportDate asc limit 1; RETURN linhaX; END
13dev Posted March 31, 2017 at 03:31 PM Report #603450 Posted March 31, 2017 at 03:31 PM Consulta este site poderá te ajudar http://www.linhadecodigo.com.br/artigo/687/sql-server-funcoes-de-usuario-user-functions.aspx
jafm Posted March 31, 2017 at 03:45 PM Author Report #603451 Posted March 31, 2017 at 03:45 PM eu queria era a sintaxe MySql e nao sqlverver
HappyHippyHippo Posted April 1, 2017 at 02:32 PM Report #603466 Posted April 1, 2017 at 02:32 PM https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html IRC : sim, é algo que ainda existe >> #p@p Portugol Plus
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now