CREATE DATABASE my_test;

USE my_test;

CREATE TABLE cities (
  id int( 11 ) NOT NULL auto_increment,
  name varchar( 255 ) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

mysql> insert into cities (name) values ('Moscow');
Query OK,  1  row affected ( 0 . 03  sec)

mysql> insert into cities (name) values ('Piter');
Query OK,  1  row affected ( 0 . 00  sec)

mysql> insert into cities (name) values ('London');
Query OK,  1  row affected ( 0 . 00  sec)

mysql> select * from cities;
+ ----+--------+
 
| id | name   |
+ ----+--------+
 
|   1  | Moscow |
|   2  | Piter  |
|   3  | London |
+ ----+--------+
 
 3  rows in set ( 0 . 00  sec)


mysql> delete from cities where id= 2 ;
Query OK,  1  row affected ( 0 . 01  sec)

mysql> select * from cities;
+ ----+--------+
 
| id | name   |
+ ----+--------+
 
|   1  | Moscow |
|   3  | London |
+ ----+--------+
 
 2  rows in set ( 0 . 01  sec)

mysql> insert into cities (name) values ('Piter');
Query OK,  1  row affected ( 0 . 00  sec)

mysql> select * from cities;
+ ----+--------+
 
| id | name   |
+ ----+--------+
 
|   1  | Moscow |
|   4  | Piter  |
|   3  | London |
+ ----+--------+
 
 3  rows in set ( 0 . 00  sec)