Auto-Increment Issue

[gokeeffe]

In the table you can see below I have an auto-increment value I use as my primary key, currently it increments starting at 1,2,3 and so on is there anyway that I can make it go FG01,FG02,FG03 on so on. I mean can the auto-increment value be set to a value of your choice

CREATE TABLE `grind_record` (
`grind_record_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL default '0',
`secondary_exam_id` tinyint(2) unsigned NOT NULL default '0',
`subject_id` tinyint(2) unsigned NOT NULL default '0',
`secondary_level_id` tinyint(2) unsigned NOT NULL default '0',
PRIMARY KEY (`grind_record_id`),
KEY `user_id` (`user_id`,`secondary_exam_id`,`subject_id`,`secondary_level_id`)
) TYPE=InnoDB COMMENT='Grind Records' AUTO_INCREMENT=61 ;

TKs

 

[Deleted]

The primary key must be an integer

http://unixjunky.com

 

[ericbrunson]

The primary key does not have to be an integer, but you can't make an autoincrement be anything but an integer. You shouldn't put any intelligence into your primary key, anyway.