Albert Lukaszewski

If this were an enterprise database, you would probably want this hole closed and so would define the table differently. You would want to require a non-NULL value for as many columns as are necessary to ensure the security and serviceability of your database.

Using INSERT...SELECT... we can tell MySQL to draw from different tables without having to draw them into Python or to set a variable in MySQL. It functions on the following syntactic template:
INSERT INTO (target column name) SELECT FROM ;

INSERT...SELECT... allows us to draw from each of the tables to form a new one.