MySQL Forums
Forum List  »  Spanish

problemas sql
Posted by: juan jaimes valle
Date: May 19, 2017 09:01AM

hola soy nuevo en mysql y en este foro, me gustaria que me ayudaran con una sentencia sql que la hago facil en access pero en mysql me da error y la cual es la siguente:


UPDATE encuesta E LEFT JOIN mun M ON (E.mun = M.Mun) SET E.sec = M.Sec WHERE ((E.swrep = 0) AND (E.user = 1) AND (M.nom Like CONCAT('%', E.nom, '%') AND (M.pat = E.pat) AND (M.mat = E.mat) AND (M.FecNacClaEle Like E.fecnac))

el problema es en

(M.nom Like CONCAT('%', E.nom, '%')

y no se como hacerlo, le agradesco, gracias

y se me ayudaran con un tutorial para hacer los sql en mysql apartr de acces les agradecaria tambien, gracas

Options: ReplyQuote


Subject
Views
Written By
Posted
problemas sql
804
May 19, 2017 09:01AM
319
May 25, 2017 06:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.