create table my_table (
    id integer primary key not null,
    ....
);

-- or
create unique index idx_id on my_table (id);

-- or, in MySQL I think:
create table my_table (
    id integer not null auto_increment,
    ....
);