Cacher is the code snippet organizer for pro developers

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