mercredi 2 décembre 2015

Tag Database how to merge tags

I have a tag database in sqlite with the three table structure of

Table1
pid pname ppath

Table2
tid tname

Table3
pid tid

As I was entering data I entered the tags dna-binding and dna_binding is there a way to merge those tags into one (i.e. to dna-binding) and update Table3.

pid and tid are unique primary keys.

Aucun commentaire:

Enregistrer un commentaire