MySql Revelations

I am used to MS Sql when writing web based applications but recently I have started working for a company that uses MySql. This has been fairly similar in most cases but there have been some differences that I have battled to find answers to online so I thought I would put them here and hopefully they will help someone else (like me) who is newish to MySql.