add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
VERSION()
8.0.30
Records: 6  Duplicates: 0  Warnings: 0
Records: 7  Duplicates: 0  Warnings: 0
id patron_id
5569249 13
5569250 13
5569251 13
5569252 13
5569253 13
5569254 13
id pat_id dia_fin mes_fin anio_fin
4727792 5569251 1 8 2000
4727793 5569251 1 2 2001
4727794 5569251 1 6 2007
4727795 5569251 1 11 2010
4727796 5569251 1 9 2016
4727797 5569251 2 3 2020
4727798 5569251 1 1 2021
You can't specify target table 'pat_details' for update in FROM clause
id patron_id
5569249 13
5569250 13
5569251 13
5569252 13
5569253 13
5569254 13
id pat_id dia_fin mes_fin anio_fin
4727792 5569251 1 8 2000
4727793 5569251 1 2 2001
4727794 5569251 1 6 2007
4727795 5569251 1 11 2010
4727796 5569251 1 9 2016
4727797 5569251 2 3 2020
4727798 5569251 1 1 2021
Rows matched: 1  Changed: 1  Warnings: 0
id patron_id
5569249 13
5569250 13
5569251 13
5569252 13
5569253 13
5569254 13
id pat_id dia_fin mes_fin anio_fin
4727792 5569251 1 8 2000
4727793 5569251 1 2 2001
4727794 5569251 1 6 2007
4727795 5569251 1 11 2010
4727796 5569251 1 9 2016
4727797 5569251 2 3 2020
4727798 5569251 16 5 2022
Rows matched: 1  Changed: 1  Warnings: 0
id patron_id
5569249 13
5569250 13
5569251 13
5569252 13
5569253 13
5569254 13
id pat_id dia_fin mes_fin anio_fin
4727792 5569251 1 8 2000
4727793 5569251 1 2 2001
4727794 5569251 1 6 2007
4727795 5569251 1 11 2010
4727796 5569251 1 9 2016
4727797 5569251 2 3 2020
4727798 5569251 1 1 2021