Forums | Help | Site Map

Join Bytes
Login

network: 226,510 (1993 online)

bytes

PrimaryKey

Viji nellaiappan Viji nellaiappan is offline

Viji nellaiappan is offline

Newbie

Join Date: Jan 2009

Posts: 23

#1: Mar 7 '09

How to keep combination of two column as primary key in a table ?

mwasif is offline

Moderator

Join Date: Jul 2006

Location: Pakistan

Posts: 719

#2: Mar 7 '09

re: PrimaryKey

On an existing table, you can create primary key on two columns

Expand|Select|Wrap|Line Numbers

ALTER TABLE table_name ADD PRIMARY KEY ( column1 , column2 );

Reply

« previous question | next question »

Similar MySQL Database bytes

How can I find a DataRow in a DataSet by it's PrimaryKey value?(C++/CLI) (answers)
PrimaryKey Does Not Returns KeyColumns (answers)
Set primarykey to a datatable (answers)
Adding .NewRow to a datatable with a primaryKey field (answers)
the primarykey property on the datatable object (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,510 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved