EATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25));

Increment.
AUTO_INCREMENT

mysql> create table first_table
-> (ID int not null primary key auto_increment,
-> last_name varchar(25),
-> first_name varchar(25),
-> email varchar(25),
-> date_joined timestamp(14),
-> about text);

--debug-info

Business as usual.