[Resolved] Increment

[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!

[tekky]

1) searching helps
2)

from http://dev.mysql.com/doc/mysql/en/create-table.html
AUTO_INCREMENT

The initial AUTO_INCREMENT value for the table. This works for MyISAM only, for MEMORY as of MySQL 4.1, and for InnoDB as of MySQL 5.0.3. To set the first auto-increment value for engines that do not support the AUTO_INCREMENT table option, insert a dummy row with a value one less than the desired value after creating the table, and then delete the dummy row.

For engines that support the AUTO_INCREMENT table option in CREATE TABLE statements, you can also use ALTER TABLE tbl_name AUTO_INCREMENT = n to reset the AUTO_INCREMENT value.

Originally posted by 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!

[Beus]

Dear Karl, Thank you for the help.

I'm not an expert, so I don't really understand what you wrote.

I change my question, if i create a table, must I put something like that in the end? I mean I know from access that I need to set the primary key, but if I leave all else out, will it work?
eg. what if
TYPE=MyISAM AUTO_INCREMENT=4
is left out?

I mean must I put the type and else in?

Or if not, what is the value of AUTO_INCREMENT if I have 6 columns in my table?

[tekky]

No harm comes from trial and error, defining AUTO_INCREMENT will set the next value to be used by the server when allowing it to auto increment the databases auto index column