Category Archives: mySQL

Replacing Join Conditions with USING

Select * From engagement_final left Join Film Using (film_master_id) Where date_on > ‘2013-04-01′

Posted in mySQL | Comments Off

mySQL in Synology

Database stored in /volume1/@database/mysql Any changes to the databases need stop the service under web services Command to stop mySQL /usr/syno/etc/rc.d/S21mysql.sh stop To reset password: Control Panel – Restore Defaults

Posted in mySQL, synology | Comments Off