,

How to add Primary Key and Auto Increment on different fields of MySql

 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 stucture I want to make the "Category" as Primary Key and "CategoryId" as Auto Increment.

But Table Wizard always give errors so, I decided to write my own Statement.

Following is the statement which will create perfect structure according to my requirement.

DROP TABLE `dbname`.`categorymaster`;
CREATE TABLE `categorymaster` (
  `CategoryId` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Category` varchar(200) DEFAULT NULL,
  `IsActiv` int(11) DEFAULT NULL,
  `ImagePath` varchar(200) DEFAULT NULL,
  `DisplayOrder` int(11) DEFAULT NULL,
  UNIQUE KEY `CategoryId` (`CategoryId`),
   PRIMARY KEY (`Category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Share:

42 comments:

Unknown said...

Thanks for sharing this. We're hoping to get some of this implemented by next quarter. This'll make things much easier. Thiago | http://www.cvd.net.au/cvd-solutions.html

.Net training in Lucknow said...

useful post... Thanks for sharing.

Unknown said...

Inbound Technical Support call | Call at: +91 981-142-0083 | inbound calls for tech support | tech support inbound calls A great online marketing company for tech support inbound calls, Inbound Technical Support call by osiel web

Unknown said...

Hey I was doing some research on "Complete IT Solutions" when I came across here at this Awesome post.

Unknown said...

It is an informative blog. I hope you would share more writing for helping us. economical It solutions are the need of everyone now a day that’s why the business of running a software house in developing.

james brownn said...

This is such a great resource that you providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It is the old what goes around comes around routine.
SEO services pakistan

Web Development Company in India said...

Thank you so much for sharing. Well described. It helped a lot.

blogger said...

Thanks for sharing sql connection command. Yburis Infotech Pvt Ltd full IT solution provider company. For any help contact us.

Adarsh Bagwani said...

Thanks for posting useful information.You have provided an nice article.
Please do visit my website hope you'll like it: Best nursery plants in Jaunpur
Best nursery services
Best Nursery plants
Best Bagwani services

Meal4U said...

I have read many of your post and this post is wonderful.... all of your post are just awesome
Please do visit my website hope you'll like it: Best tiffin service provider in Lucknow
Best Tiffin service in Lucknow
Best Tiffin Service
Best Homemade Food

Priya Singh said...

Thank you so much for sharing this article. if you want to get if you want to get any type of information about software or website then visit us.

Akhand Pratap Singh said...

Bigtown group is the best real estate comapny in lucknow
we provide luxirious homes and apartments in lucknow
for more info visit us: Bigtown Group

SOftware Development in London said...

I personally recommend this blog, the links that the person has shared are fantastic.
IT Support in London
Software Development in London
Software Development in London
Money Transfer Software
Money Transfer System

Priya Singh said...

Thank you so much for this blog. Your post is very helpful for me. Inspired by you I have created a website Accounting and Billing software for small business.
Please visit my website

Pradeep Tiwari said...

Thank you so much for this blog. Your post is very helpful for me. If you want to get more information about software and website.
So Please visit my website

Ashish Singh said...

Thanks for sharing such a piece of information.

Software Development Company in Lucknow

theexpertize said...

Nice Blog with great tips
thanks for sharing.....
Data Analytics Training in Lucknow
HR Training in Lucknow
Business Training in Lucknow
Advance Excel training in Lucknow
Graphic designing in Lucknow
Personality Development Training In Lucknow
Digital Marketing Training Institute in Lucknow

Auctech IT Solution said...

Nice Blog with Excellent tips
thanks for sharing.....
3D Walkthrough Company
3D graphics company in lucknow
Website development and Digital Marketing In Lucknow
Motion Graphic Company in Lucknow
Brochure Design Company In Lucknow
3D Company in Lucknow
Graphic Design In Lucknow
3D Walkthrough Animation Services
3D Architechural Walkthrough Services

Advanced Excel Training in Lucknow said...

Thanks for sharing valuable content I appreciate your efforts, we are basedin Lucknow and our courses are as follows:
Data Analytics training in Lucknow
Data Analysis training in Lucknow
Advanced Excel training in Lucknow
Digital marketing training in Lucknow
Human Resource training in Lucknow
Graphic Designing training in Lucknow
Advanced Excel training in Lucknow

VINAY SINGH said...

Useful information Thank-you for sharing. really helpful keep sharing your views. Please visit link mentioned below and share your views on them.
hvac training in lucknow
autocad training in lucknow
php training in lucknow
python training in lucknow
account and finance training institute in lucknow
digital marketing training in lucknow

SIPL training said...

SIPL

Thank you so much for sharing this information.

SAP training in lucknow
HVAC training in lucknow
Digital Marketing training in lucknow
SEO training in lucknow
Python training in lucknow
REVIT MEP training in lucknow

Anonymous said...

Great article, It's one of the best content in your site. I really impressed the post. Good work keep it up. Thanks for sharing the wonderful post.See also Best International School.
Best CBSE School in Ballia

MLM Softonline said...

Awesome Blog Post Informative Content
Regards
Software Company in Kanpur

Anonymous said...

Great article, It's one of the best content in your site. I really impressed the post. Good work keep it up. Thanks for sharing the wonderful post.
Best Chicken kurti

SAP Training in Lucknow said...

Its really great being a content writer I can understand how tough is it to write and develop the content ,Thanks for sharing this wonderful informationSAP Training in Lucknow 
Digital marketing training in Lucknow 
AUTOCAD Training in Lucknow  
PHP Training in Lucknow  
SAP FICO Training in Lucknow  

maxwell said...

Everyone wishes to pass on a Largest Android Tablets? with them. Nevertheless, the greatest screen tablets are not conveniently found. Tablets are the hugest electronic device that people like to pass on.

Paul hallen said...

Get extremely comfortable rides from and to Charles M. Schulz–Sonoma County Airport Limo Transfer and enjoy your journey.

Kashi Digital Agency said...

Nice to be visiting your blog again, it has been months for me.

Leading Website Design Company India - Free Domain - Free Hosting | We Are Providing Low Cost Affordable Web Designing For Startups, Small & Medium Business Who Wants To Have Their Online Presence.Website Design Company India - Free Domain - Free Hosting

Reliance Beauty & Health said...

Hey Nice Blog!!! Thank you for sharing information. Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
Manufacturer & Suppliers of Healthcare Products, Beat covid-19 Products, Hand Sanitizer, Hand Sanitizer Dispenser, Air Purifier, Disposable Face Mask, N95 mask, FFP2 respiratory, Surgical Mask, Collagen Mask,Peal-off Mud Mask,Beauty Equipment, OEM, ODM, Private Label. Manufacturer & Suppliers of Covid-19 Products

Sam said...

you have definitely done some serious research! i like it when someone do theirwork with such devotion digital marketing agency

Sam said...

Great Article & Thanks for sharing. samdigitech

Veronica Kate said...

Hi, I am Veronica Kate. I am working as a full-time academic consultant with Livewebtutors. We are providing paper editing service and Deakin Referencing Generator to university and college students across the globe. I have been successfully helping students, scholars and professionals in various services like I mentioned above for more than 5 syears and hold excellent writing, proofreading and editing skills. You would also find various academic tools on Livewebtutors like Paraphrasing Tool and Harvard Referencing Generator.

source codes said...

Thank you for sharing this informative content. It's really very helpful.

Best Software Development Company in Nashik
Digital marketing company in nashik
Digital marketing training in nashik
Academic Projects provider in nashik
ERP software provider in nashik
Billing software provider in nashik

Software development company in Lucknow said...

Thank you for informing SQL Solution. Contact us for website designing information.

Radhya said...

Big Aquatic is a software company that provides the best software compared to another provider. Visit my profile.

Krishna Kushwaha said...

Hi !
You’ve outdone yourself this time.
This is probably the best, most concise step by step guide I’ve ever seen on how to build a successful blog.
Thank you so much.

bogsspecialist said...

I was more than happy to uncover this great site. I need to to thank you for your time due to this fantastic read!!
I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
Classified Ads WordPress Theme

bogsspecialist said...


I was more than happy to uncover this great site. I need to to thank you for your time due to this fantastic read!!
I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
Freelance Marketplace WordPress Theme

bogsspecialist said...

I was more than happy to uncover this great site. I need to thank you for your time due to this fantastic read!!
I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
Classified Ads WordPress Theme

Best Digital & OOH Advertising Agency said...

Thanks for sharing this amazing post. It's very helpful. Keep Sharing like this in the future.

bogsspecialist said...

I was more than happy to uncover this great site. I need to thank you for your time due to this fantastic read!!
I definitely enjoyed every bit of it and I have you bookmarked to see new information on your blog.
WordPress Chat Plugin

SignatureIT said...

Our company (Signature IT Software) is the best mlm software company in lucknow. mlm software company in lucknow, mlm software in lucknow, mlm company in lucknow.
mlm software company in lucknow