problem in primary keys

[KADRI]

Hello to all,
I am new to this forum. I recently started learning SQL language. I have create one table in which there are three columns namely ids, tags1, tags2. In this ids is a primary key. In that I want one unique tags1-tags2-combination. So I have made three columns primary keys but the problem is that the second entry is inserted in another column. I don't know what is the problem in primary keys. Please help me to fix this problem.

[absolute55]

It seems that you are tried to add same data in two different table and you are tried to assign different primary key for these two table and that's why you are getting such type of problem. In this case you have to merge two table in one table to fix this problem. For Eg. Make table like as follows:
IDs
tags1: cat
tags2: mouse
tags3: dog

[Reegan]

As per my knowledge you have to leave IDs as the primary key and after you have to create a unique constraint for the tags1 and tags2 to fix this problem. You have to use following code in your program to fix this problem.

ALTER TABLE mys_table ADD CONSTRAINT ucs_tags UNIQUE (tags1, tags2)

In the above code I ave use unique constraint to avoid two rows with duplicate tags1 and tags2 values.

[opaper]

You have to use UNIQUE constraint in your code to fix this problem. It is very easy to use. This technique uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints provides uniqueness for a column. Fro better understanding look at below example.

CREATE TABLE Personss
(
Ps_Ids int NOT NULL,
LastNames varchar(268) NOT NULL,
FirstNames varchar(232),
Addresss varchar(269),
Citys varchar(236),
UNIQUE (P_Ids)
)

[MindSpace]

You have to add unique index that combines tags1 and tags2. You also have to use CREATE INDEX to fix this problem. CREATE INDEX is used to mapped to an ALTER TABLE statement to create indexes. It is very easy to implement and use. I have written syntax of this. Just try to use it in your code.

CREATE [ONLINEs|OFFLINEs] [UNIQUEs|FULLTEXTs|SPATIALs] INDEX index_name
    [indexs_types]
    ON tabls_name (indexs_cols_names,...)
    [indexs_options] ...

indexs_cols_names:
    cols_names [(length)] [ASC | DESC]

[Modifier]

You have to create TempWork table with same structure as the final destination table. It is very simple one. You also have to use "unique record" to fix this problem. You also have to use "id" to fix this problem. You also have to use primary key for tags1 and tags2. It is very simple code. Just try to understand it.