Normal code generated by MySql:-
CREATE TABLE `categorymaster` (
`CategoryID` int(11) NOT NULL AUTO_INCREMENT,
`Category` varchar(200) DEFAULT NULL,
`IsActiv` int(11) DEFAULT NULL,
`ImagePath` varchar(200) DEFAULT NULL,
`DisplayOrder` int(11) DEFAULT NULL,
PRIMARY KEY (`Category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
In the above data...
How to add Primary Key and Auto Increment on different fields of MySql
