is there more the two primary key in a single table?
Answer Posted / murugavel
yes
CREATE TABLE "accessmenu" (
"UID" int(11) NOT NULL DEFAULT '0',
"MID" int(11) NOT NULL DEFAULT '0',
"AlterPermission" tinyint(4) DEFAULT '0',
PRIMARY KEY ("UID","MID")
);
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is onf in normalization form?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between mysql and mysqli?
What are the types of database recovery models?
What is normalization 1nf 2nf 3nf?
What action plan is preferred if sql server is not responding?
Write a SQL query to delete a table?
What do you mean by an execution plan?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the difference between join and inner join?
Describe how to use linked server?
What is built-in/administrator?
What is a non-clustered index?
What is the need for indexing?
Is it possible in sql table to have more than one foreign key?