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 |