creating table syntax error
You don't use single quotes ' to quote identifiers in MySQL.  You use a backtick ` or you can use nothing at all, if the identifier isn't a reserved word. 

'mid_initials' (255) IS NULL,


Should be

`mid_initials` VARCHAR(255) DEFAULT NULL,


...although using a VARCHAR(255) seems unnecessarily large.