tracks title plays thunderstruck my way figure rows in table first we insert two rows into our table and use commit(to force the data to be written to the database file then we use the select command to retrieve the rows we just inserted from the table on the select commandwe indicate which columns we would like (titleplaysand indicate which table we want to retrieve the data from after we execute the select statementthe cursor is something we can loop through in for statement for efficiencythe cursor does not read all of the data from the database when we execute the select statement insteadthe data is read on demand as we loop through the rows in the for statement the output of the program is as followstracks('thunderstruck' ('my way' our for loop finds two rowsand each row is python tuple with the first value as the title and the second value as the number of plays noteyou may see strings starting with uin other books or on the internet this was an indication in python that the strings are unicodestrings that are capable of storing non-latin character sets in python all strings are unicode strings by default at the very end of the programwe execute an sql command to delete the rows we have just created so we can run the program over and over the delete command shows the use of where clause that allows us to express selection criterion so that we can ask the database to apply the command to only the rows that match the criterion in this example the criterion happens to apply to all the rows so we empty the table out so we can run the program repeatedly after the delete is performedwe also call commit(to force the data to be removed from the database structured query language summary so farwe have been using the structured query language in our python examples and have covered many of the basics of the sql commands in this sectionwe look at the sql language in particular and give an overview of sql syntax