Is it possible to create sequence in mysql?
<p>I am developing product named HMIS (Hospital Management Information System)</p>

<p>I want to create UHID no (Unique Hospital Identity No)?</p>

<p>How can I create alphanumeric unique no that can be shared accross two tables in mysql?</p>

<p>(Above scenario can be possible in Oracle DB because it allows me to create sequence.)</p>