Gavin Towey questions

Gavin Towey answers

• Where does MySQL on OSX write outfiles by default?
• Disk space implications of setting MySQL column value to NULL instead of 0 or ''
• MySQL index name and foreign key name must be different for different tables?
• Cannot alter schema name in MYSQL 5.5 w/ MYSQL Workbench
• MySql: is it possible to 'SUM IF' or to 'COUNT IF'?