Check with sql if two tables are unique PHP

Question

How can I check in MYSQL PHP if two columns are unique then not insert again, else if just one column is unique then insert, is that even possible to do in php?

EDIT:

Lets say I have a table like this,

userId  |  codeId

And I I send a query like this,

$query = $pdo->prepare('insert into table (userId, codeId) values (?,?)');

So now I want to check if userId and codeId are added already once do not insert again, and if just one is added, then do insert the entire query,

I hope its more understanding.

I don't get it. Could you elaborate more and maybe show examples? A good question makes good answers. — kapa
– kapa, Commented Jul 6, 2012 at 14:30
I updated, please let me know if that makes sense for you, thanks for your time — itsme
– itsme, Commented Jul 6, 2012 at 14:38

Naftali · Accepted Answer · 2012-07-06 14:31:22Z

2

Set up a unique key for those columns, then the mysql query will FAIL when you try to insert.

answered Jul 6, 2012 at 14:31

Naftali

147k41 gold badges247 silver badges304 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

itsme Over a year ago

But if when I try to insert the columns and just one column has a duplicated entry and one don't have, I want the query should insert the new one, even one of the columns are duplicated, is that possible to do?

Naftali Over a year ago

@itsme you can set a unique key for a set of columns. And it will only fail if both are the same.

Naftali Over a year ago

@itsme I am happy to help ^_^

Clément Andraud · Accepted Answer · 2012-07-06 14:31:52Z

1

Use REPLACE INTO instead of INSERT INTO ... ?

answered Jul 6, 2012 at 14:31

Clément Andraud

9,24927 gold badges89 silver badges162 bronze badges

1 Comment

Maykonn Over a year ago

REPLACE INTO will DELETE and INSERT again, but this is not the desired behavior. The behavior must be: It then duplicate key: UPDATE, else: INSERT.

Maykonn · Accepted Answer · 2012-07-06 14:51:23Z

0

Do something like the code below (where TEXT_ID and TEXT_CATEGORY, are keys of table):

INSERT INTO 
    table_texts
SET 
    text_id = 174,
    text_category = "pam_texto"
ON DUPLICATE KEY UPDATE 
    text_id = 174,
    text_category = "pam_texto";

The above code tries to insert, but if the keys are duplicated performs an update on the line.

answered Jul 6, 2012 at 14:51

Maykonn

2,9687 gold badges35 silver badges53 bronze badges

Collectives™ on Stack Overflow

Check with sql if two tables are unique PHP

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related