Thanks for your response. It will delete from Author_Books when book deleted.
I am trying minimize queries on Authors table. For every deletion of record from Books, it needs to check in Authors table. One extra query execution is there. I am trying minimize that. On Wed, Jun 12, 2013 at 1:00 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > dd wrote: > > my app need to delete author record from author table when author > > doesn't have any books. How to handle this? (I can verify in author > > table, whether this author belongs to any other book when book > > deletion. > > You mean the Author_Books table. > > > If no, delete from author table. > > That's how it's done. > > > I am not happy with this solution > > Why not? > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
