cursor.execute(
    """
            INSERT INTO Songs (SongName, SongArtist, SongAlbum, SongGenre, SongLength, SongLocation)
            VALUES
                (%s, %s, %s, %s, %s, %s)
        """
    , (var1, var2, var3, var4, var5, var6))
Python MySQL Parameterized Queries