What does it mean?

[Beus]

Hello all! I'm glad I've found this forum, for all my friends are very busy to answer my questions. Well let's start.
In my example the tutorial didn't say what the number after AUTO_INCREMENT= means, please help!

//create "movie" table
$movie = "CREATE TABLE movie (
movie_id int(11) NOT NULL auto_increment,
movie_name varchar(255) NOT NULL,
movie_type tinyint(2) NOT NULL default 0,
movie_year int(4) NOT NULL default 0,
movie_leadactor int(11) NOT NULL default 0,
movie_director int(11) NOT NULL default 0,
PRIMARY KEY (movie_id),
KEY movie_type (movie_type,movie_year)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

Thank you!

---

Regards, Beus

[planetsim]

This is probably more appropriate in the Newbies forum.

MySQL Manual on AUTO_INCREMENT

Basically its combined with a Primary key to increment the Primary key by 1, and is numeric.