I want to let each release have a unique release id
I'm using sqlitebrowser.
update songs
set release_id = (
select min(release_id)
from songs t2
where t2.release = songs.release
)
I used this command. but I have 100000 rows. And my computer has been getting stuck for an hour. It can get result if I delete row to 20.
Any better solution?
Aucun commentaire:
Enregistrer un commentaire