Adding composite primary key in MySQL
ALTER TABLE tablename
DROP PRIMARY KEY,
ADD PRIMARY KEY (columnID1,columnID2,columnID3);
Showing posts with label composite primary key. Show all posts
Showing posts with label composite primary key. Show all posts
Friday, December 14, 2012
How to add composite primary key in MySQL
ALTER TABLE tablename
DROP PRIMARY KEY,
ADD PRIMARY KEY (columnID1,columnID2,columnID3);
Subscribe to:
Posts (Atom)
Popular Posts
-
In this post I would like to share some thing regarding Entity Framework, how we can implement CRUD operations using stored procedures in E... -
In this blog I am going to show how we can work with cascading dropdown list for country/state/city in asp.net using Entity Framework. ... -
I have attended an interview, there I asked a question like how to create a Tab container in asp.net dynamically with the department name fr... -
Create a table in SQL server as follows USE [forumDB1] GO /****** Object: Table [dbo].[users] Script Date: 01/23/2013 11:25:... -
In this article I will explain how we can work with Dynamic Data Entities Web Application which is available at the time of creating a p... -
Hi all in this blog I would like to show you how we can create a forums application using MVC4 along with entity framework. Database ... -
Adding composite primary key in MySQL ALTER TABLE tablename DROP PRIMARY KEY, ADD PRIMARY KEY ( columnID1 , columnID2 , columnID3...
-
In this post I am going to explain how we can validate two DateEdit controls which are Devexpress controls using CustomValidator. First d...
-
Have you ever come across the warning System.Configuration.ConfigurationSettings.AppSettings' is obsolete: '"This method is o... -
In the last blog I posted how can directly call Stored Procedures with out mapping them to a Model. Check here Entity Framework Download...