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`)

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`)


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...

Earn from Ur Website or Blog thr PayOffers.in!


Nice to e-meet you. A very warm greetings from PayOffers Publisher Team.

I am Sanaya Publisher Development Manager @ PayOffers Publisher Team.

I would like to introduce you and invite you to our platform, PayOffers.in which is one of the fastest growing Indian Publisher Network.

If you're looking for an excellent way to convert your Website / Blog visitors into revenue-generating customers, join the PayOffers.in Publisher Network today!

Why to join in PayOffers.in Indian Publisher Network?

* Highest payout Indian Lead, Sale, CPA, CPS, CPI Offers.
* Only Publisher Network pays Weekly to Publishers.
* Weekly payments trough Direct Bank Deposit,Paypal.com & Checks.
* Referral payouts.
* Best chance to make extra money from your website.

Join PayOffers.in and earn extra money from your Website / Blog


If you have any questions in your mind please let us know and you can connect us on the mentioned email ID info@payoffers.in

I’m looking forward to helping you generate record-breaking profits!

Thanks for your time, hope to hear from you soon,
The team at PayOffers.in

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.

Career Maker Infra said...

Nice blog..! I really loved reading through this article.Thanks for sharing.
Please do visit my website hope you'll like it:
Best real estate company in Lucknow
Best properties in Lucknow
Best plots in Lucknow
Fastest growing real estate company in Lucknow
Best Real estate company
Best development company in Lucknow

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

Ashish Singh said...

Nice Blog! Thanks for sharing.
Website Development Company in Lucknow 

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


Nice Blog With Full of Knowledge
Thanks For Sharing.....
Best Teen Patti Game In India
Teen Patti Game in India
Online Teen Patti App In India
3 Patti Game App in India
Best 3 Patti In India
3 Patti Online In India
Teen Patti Gaming App Development Company In India
3 patti Jobs in India
Teen Patti Career in India
Teen Patti Gaming Software In India
Teen Patti Game Development Plateform services
Teen patti Mobile App Development
Teen patti For Mobile Development

Casinopokerguru said...

Wonderful Post,

Thanks a lot for sharing the great piece of the information with us. I would surely refer to the steps to find an ideal casino software providers.
We are online casino games development company Casino Poker Guru. we develop the best online live casino poker sites and can hire our casino game developers.

Keep it works and share with us your latest post.

Thanks again!

URBAN AXIS said...

Nice Blog with Great Tips
Thanks for sharing.....
RERA Registered Projects
RERA Registered Projects In Lucknow
Real Estate Developers In Lucknow
Real Estate Builder In Lucknow
Best Real Estate Project In Lucknow
Best property in lucknow
Best Residential Flats In Lucknow
Affordable Flats In Lucknow


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

standwithdignity said...

Nice Blog With Full of Knowledge
Thanks For Sharing.....
Imam Hussain
Imam Hussain In USA
Ashura In USA
Arbaeen In USA
Best Teen Patti Game In India
Tragedy In karbala
Tragedy In karbala In USA
Stand With Dignity
Karbala In USA
Who is hussain Standwithdignity

SIPL training said...


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

aspetto said...


Thanks a lot for sharing this valuable and useful content with us. Being a reputational company in bulletproof suits providers in 2019. We have been on an epic ride and paved our way to becoming the Best in designing the suits in US. Aspetto known as an essential part of our voyage and we will continue to serve them better with the same loyalty and ace-quality of products. Aspetto is proud to be America's First Bullet Resistant Clothing Line. Shop for men's suits, body armor, and ballistic clothing.

We always understand your needs and provide you exactly what you want.

Thanks again for sharing valuable content with us.

Thanks & Regards!
Aspetto SEO Team

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
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  

belly sons said...

i-LEND is an online marketplace connecting borrowers and lenders for loans. Although i-LEND verifies credentials of registered users on the site, it does not guarantee any loan offers by lenders nor does it guarantee any repayments by borrowers. Users make offers/loan requests at their own discretion with the understanding of the risks involved in such transactions including loss of entire capital and/or no guarantee of recovery. Please read our Legal agreements to understand more. borrow money

Amit said...

Second Innings Home is the first and only premium home & health care service in India. Second Innings Home proposed across the nation features a beautiful campus ideally located in a well-maintained gated community in the format of a Star Hotel with luxurious amenities. It’s convenient to enjoy the privacy and to be near the city and nearby facilities. And yet it retains a sense of community spirit and the warmth of a small community. good retirement homes in Hyderabad

maxwell said...

Are you wishing to purchase the best work socks for sweaty feet ? Well, everyone desires to buy because bb guns are the best for Airgun sports. People use these guns for target practice and training.

Netzent Technologies 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!
Web Designing Services
Web Development Services
Software Development Services
Mobile Applications Services
Bulk SMS Services
Domain and Hosting Services
Maintenance & Support Services
Software Testing Services
IT Consulting Services

Rohit said...

Great Article & Thanks for sharing.

Oflox Is The Best Digital Marketing Company In Dehradun Or Digital Marketing Institute In Dehradun

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.

Paul hallen said...

if you are looking for a reliable limo service for your airport trips, look no more and book London Heathrow Airport Limo Transfer now!

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