I had to do auto increment in Oracle a while back and it was painful. It ended up happening, but not in the nice MySQL way. Whatever, it worked.

This site has a few tricks.

Autoincrement primary key for Oracle