def help_nextset_setUp(self, cur):
        """Should create a procedure called deleteme
        that returns two result sets, first the
        number of rows in booze then "name from booze"
        """
        sql = """
           create procedure deleteme()
           begin
               select count(*) from %(tp)sbooze;
               select name from %(tp)sbooze;
           end
        """ % dict(
            tp=self.table_prefix
        )
        cur.execute(sql)
Should create a procedure called deleteme
        that returns two result sets, first the
        number of rows in booze then "name from booze"
        
pymysql/tests/thirdparty/test_MySQLdb/test_MySQLdb_dbapi20.py