Hi guys! I'm currently making an integration of 2 different web apps. I would to ask if is it possible to restrict adding duplicate data in your table.
i have two different tables from two different databases.
App1_Invoice (from Web App 1 database)
App2_Invoice (from Web App 2 database)
id, <- AUTO_INCREMENT PRIMARY KEY
I will Insert App1_Invoice.transno to App2_Invoice.transno
and so on so forth.
(I can't alter the App2_Invoice Table. it might ruin the whole Web App2)
but anyway, Is there any way in SQL to restrict that?! since the Primary key for App2_Invoice is Auto Increment
everytime i run the script and hit the button. It will just add. of course the SQL cannot read this as duplicate since the APP2_Invoice.id is always Incrementing everytime you add.
is there any way using SQL command?! or do i have to do it the hard way?!
All helps, Comments, Suggestion or even Snippets ;) is Deeply much Appreciated.
Edited by pritaeas: Moved.