Mage a table without getting the duplicates... and anothers functions.

[angeloghiotto]

MySQL version 5.1.56

 

heelo, i want to merge two identical tables without get the duplicate values, and.. if a duplicate appears i want to plus 1 to the hit column... that's possible?!

 

Like:

 

Table 1

Columns : A  -  B

Values:  Hi - 0

Values:  Hello - 0

 

Table 2

Columns : A  -  B

Values:  Hi - 0

Values:  Nice - 0

 

 

New Table 3

Columns : A  -  B

Values:  Hi - 1

Values:  Nice - 0

Values:  Hello - 0

 

 

.

 

Understand?

 

Thanks in advance.

[Muddy_Funster]

not with the information that you have given I don't think.  There may be a couple of methods that will get the results that you are looking for, but we will need to know exactly what you are doing.  Are you creating a new table?  could you provide your actual table structure for the database that you are working on?

[angeloghiotto]

Yes, i'm creating a new table.

 

Table structure: ( the both table have the same structure... )

 

Uploaded with ImageShack.us

[fenway]

That's what INSERT... ON DUPLICATE KEY UPDATE... is for.