Try this:
When you add an AUTO_INCREMENT column, column values are filled in with sequence
numbers for you automatically.
For MyISAM tables, you can set the first sequence number by executing SET
INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table
option. See section 14.
similar-ish to setting your sequence in oracle
try this:
The create table statement below will start the auto increment at 1
CREATE TABLE TableX (
X_primary_key INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
X_col1 VARCHAR(20) NOT NULL,
X_col2 VARCHAR(40) NOT NULL,
X_col3 VARCHAR(10) NOT NU
