I have a table 's' containing strings:
- 'STRING_A'
- 'STRING_B'
- 'STRING_C'
- 'STRING_D'
- 'STRING_E'
and a list of strings that i want to insert into 's':
- 'STRING_C'
- 'STRING_D'
- 'STRING_E'
- 'STRING_B'
- 'STRING_A'
I want to insert only those items that do not overlap with records in the table 's'.
Result table 's':
- 'STRING_A'
- 'STRING_B'
- 'STRING_C'
- 'STRING_D'
- 'STRING_E'
- 'STRING_B'
- 'STRING_A'
Can it be done without leaving sql?
Aucun commentaire:
Enregistrer un commentaire