Skip to Main Content
Python GUI Programming Cookbook
book

Python GUI Programming Cookbook

by Burkhard Meier
December 2015
Beginner to intermediate content levelBeginner to intermediate
350 pages
6h 49m
English
Packt Publishing
Content preview from Python GUI Programming Cookbook

Using the SQL DELETE command

In this recipe, we will use the SQL DELETE command to delete the data we created in the previous recipes.

While deleting data might at first sight sound trivial, once we get a rather large database design in production, things might not be that easy any more.

Because we have designed our GUI database by relating two tables via a primary to foreign key relation, when we delete certain data we do not end up with orphan records because this database design takes care of cascading deletes.

Getting ready

This recipe uses the MySQL database, tables, as well as the data inserted into those tables from the previous recipes in this chapter. In order to show how to create orphan records, we will have to change the design of one ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Python GUI Programming - A Complete Reference Guide

Python GUI Programming - A Complete Reference Guide

Alan D. Moore, B. M. Harwani
Python Network Programming Cookbook - Second Edition

Python Network Programming Cookbook - Second Edition

Pradeeban Kathiravelu, Dr. M. O. Faruque Sarker

Publisher Resources

ISBN: 9781785283758Supplemental Content