Aukom
UPDATE tx_datamintstrainingmanager_domain_model_trainings AS t
LEFT JOIN aukom_kurse AS ak ON t.uid = ak.lfdnr
SET
users = 158
WHERE ak.trainer1 = 2492
mysqldump -uUSER -pPASSWORT -hHOST --verbose --no-create-db --no-create-info --database DATABASE --tables tx_datamintstrainingmanager_domain_model_trainings tx_datamintstrainingmanager_domain_model_students tx_datamintstrainingmanager_domain_model_studentcertificates tx_datamintstrainingmanager_domain_model_trainingfilerelations tx_datamintstrainingmanager_domain_model_trainingfiles > NAME.sql