most valuable SQL-Statement – TYPO3 switch to textmedia

UPDATE tt_content 
LEFT JOIN sys_file_reference ON sys_file_reference.uid_foreign=tt_content.uid 
AND sys_file_reference.tablenames='tt_content' 
AND sys_file_reference.fieldname='image' 
SET tt_content.CType='textmedia', tt_content.assets=tt_content.image, tt_content.image=0, sys_file_reference.fieldname='assets' 
WHERE tt_content.CType='textpic' OR tt_content.CType='image';

https://blog.undkonsorten.com/typo3-update-upgrade-typo3-95