Re: Dependent Insert

[Huu Da Tran]

That's exactly what I said: put a unique index (T1GUID, FamilyName) in your table definition to have the two last columns unique together.

Stored procedures are DBMS specific. Each one has its own "programming" language.

It's hard to suggest a way to do it since we don't really know how your system works. Do you have thousand records each second or in a day? in an hour? It all depends on load. You may retrieve list of known colors, look through the list of colors you try to use, find out which one don't exist, add them. In the next step, you would not need to care if it exists or not, because you already validated it.

Good luck,

Huu Da
MySQL flirter