samedi 10 octobre 2015

How to INSERT a random integer within a range into a row using SQLite?

I have a table that looks like this:

 TableA
 entry_id       related_id

 RelatedTable
 related_id

What I exactly want to do is insert integer ids into TableA's column related_id. The integer inserted into the column should also be an existing id inside the RelatedTable table.

Is there a way to do this?

Aucun commentaire:

Enregistrer un commentaire