PostgreSQL to MySQL

Hi I am trying to create an application in Java using MySQL. Previously I have created a couple of small apps with PostgreSQL.

My problem is, what is the equivalent in MySQL for this statement:

create sequence dbname.entity_id_sequence;

and then the corresponding statement to get the next id previously in PostgreSQL it would be:

DEFAULT nextval('dbname.entity_id_sequence')

what would it be now?

[436 byte] By [boom_zapa] at [2007-10-2 20:10:21]