I start hacking by erlang and mnesia database, so I might not face your mysql issues.

> How do you generate that shortened code? Can the same URL have different codes?

It depends, I will assign random hash to the specified URL.