Just trying to get a grasp on database concepts, but it seems like I could just edit a database using .execute statements, if that's true, what is the purpose of a recordset?

Also, going through on a trial run with a mysql database, I've managed to save an entry (using a recordset), but how do I save any changes to the actual database? Thanks.