MySQL to Liquibase

General Discussion
1

Hello, is there a way to do the following in Liquibase ? (update with inner join in it)


  2. /* Récupération du type élément SUIVI */
  3. SET @idTYPESUIVI = (SELECT idTYPEELEMENT FROM mv_typeElement WHERE valeur LIKE 'SUIVI' LIMIT 1);

  5. /* Mise à jour des warnings vu et non vu pour les patients sorties */
  6. UPDATE wrg_warning AS WRG 
  7. -- SELECT WRG.* FROM wrg_warning AS WRG 
  8. INNER JOIN wrg_typeWarning AS TW ON TW.idTYPEWARNING = WRG.idTYPEWARNING
  9. SEJOUR.dateSortieEffective != '0000-00-00 00:00:00';
thanks previously :)
2

Not with the tag, but you can use the tag and put that in directly


Nathan