You should type:
mysql> ALTER TABLE customerCases CHANGE recordno recordno int NOT NULL AUTO_INCREMENT;
B.
mysql> ALTER TABLE customerCases CHANGE recordno recordno int NOT NULL AUTO_INCREMENT;
B.
Subject | Author | Views | Date |
---|---|---|---|
Primary Key | jai | 11928 | Mar 4, 2002, 4:04 AM |
Re: [jai] Primary Key | Paul | 11716 | Mar 4, 2002, 6:36 AM |
Re: [RedRum] Primary Key | jai | 11744 | Mar 4, 2002, 3:42 PM |
Re: [jai] Primary Key | 604 | 11756 | Mar 4, 2002, 3:54 PM |
Re: [TheStone] Primary Key | jai | 11705 | Mar 4, 2002, 4:51 PM |
Re: [jai] Primary Key | 604 | 11669 | Mar 4, 2002, 4:58 PM |
Re: [TheStone] Primary Key | Reena0330 | 11361 | Aug 9, 2002, 1:48 PM |
Re: [Reena0330] Primary Key | 604 | 11446 | Aug 9, 2002, 1:59 PM |
Re: [TheStone] Primary Key | Reena0330 | 11401 | Aug 9, 2002, 2:10 PM |
Re: [TheStone] Primary Key | Reena0330 | 11378 | Aug 9, 2002, 2:19 PM |
Re: [Reena0330] Primary Key | 604 | 11413 | Aug 9, 2002, 2:33 PM |
Re: [TheStone] Primary Key | Reena0330 | 11361 | Aug 9, 2002, 2:45 PM |
Re: [Reena0330] Primary Key | 604 | 11367 | Aug 9, 2002, 2:55 PM |
Re: [TheStone] Primary Key | Reena0330 | 11354 | Aug 9, 2002, 3:20 PM |
Re: [Reena0330] Primary Key | 604 | 11358 | Aug 9, 2002, 3:27 PM |
Re: [TheStone] Primary Key | Reena0330 | 11428 | Aug 9, 2002, 3:32 PM |
Re: [Reena0330] Primary Key | 604 | 11352 | Aug 9, 2002, 3:37 PM |
Re: [TheStone] Primary Key | Reena0330 | 11332 | Aug 9, 2002, 3:52 PM |
Re: [Reena0330] Primary Key | 604 | 11396 | Aug 9, 2002, 4:14 PM |
Re: [TheStone] Primary Key | Reena0330 | 11339 | Aug 12, 2002, 11:02 AM |