auto increment

[ceanth]

Hi all, what is the command for auto incrementing. I want an increment of a student number to be s0001, s0002, and so on.

Also would this be different for normal SQL?

many thanks

ceanth

[mogster]

Here's an example:

CREATE TABLE `review_article` (
  `article_id` int(10) unsigned zerofill NOT NULL auto_increment,
  `reg_time` int(20) NOT NULL default '0',
  `headline` varchar(150) NOT NULL default '0',
  `main_text` text,
  PRIMARY KEY  (`article_id`)
) TYPE=MyISAM;

Look at the top line article_id.

The field needs to be an int, so you can't have the s before your id's 😉

knutm

[eoghain]

If you are speaking about the auto increment functionality of the MySQL database, then this is a modifier that you add to an int field in your table creation script to cause the field to auto increment, and then you will get ever increasing integer values. There is no database that I know of that will increment a string.

CREATE TABLE students (
student_id int not null auto_increment primary key,
name varchar(50));

[ceanth]

if i wanted the s before the id would setting the student number to varchar work? also how do i assign where the autoincrement starts from (as in increment from s2000 etc)

[mogster]

The varchar may not be incremented 😉

As for the second problem: try to manually set your first record to 2000.

knutm