You don't need to name/alias the returning value [LAST_INSERT_ID()].

Also check the version of MySQL you are using - error 1064 is when a reserved word that was allowed in a previous version is now deprecated. Maybe using aliasing on a returned value is not allowed.