UPDATE Varios campos a la vez

update notas.award na set ruta_img = concat('https://s3.amazonaws.com/smiledu.avantgard/public/general/img/meritos/',tab.r,'.png') from (select ruta_img as r, id_award as ia from notas.award) tab where na.id_award = tab.ia

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.