import mysql.connector as connector

    def select_computed_series_ids(self):
        connection = None
        cursor = None
        try:
            connection = connector.connect(
                host=self.__host, database=self.__database, password=self.__password, user=self.__user)
            cursor = connection.cursor()
            cursor.execute("""
SELECT series_id
    FROM series AS
    WHERE status <> 'X'
-- LIMIT 5
""")
            return {item[0] for item in cursor}
        finally:
            if cursor:
                cursor.close()
            if connection:
                connection.close()

    def select_computed_series_ids(self):
        connection = None
        cursor = None
        try:
            connection = connector.connect(
                host=self.__host, database=self.__database, password=self.__password, user=self.__user)
            cursor = connection.cursor(prepared=True)
            query = """
SELECT series_id
    FROM series 
    WHERE series_id > %s
      AND status <> 'X'
    ORDER BY series_id
LIMIT 1000
"""
            last_series_id = 0
            ids = []
            while True:
                cursor.execute(query, (last_series_id,))
                row = cursor.fetchone()
                if row is None:
                    break
                while row is not None:
                    last_series_id = row[0]
                    ids.append(last_series_id)
                    row = cursor.fetchone()
            
            return set(ids)
        finally:
            if cursor:
                cursor.close()
            if connection:
                connection.close()

return (item[0] for item in cursor)

>>> import pymysql
>>> 
>>> con = pymysql.connect(host='localhost', user='guest')
>>> cur = con.cursor()
>>> cur.execute('use test')
0
>>> cur.execute('show tables')
2
>>> list(cur)
[('p',), ('t',)]
>>> con.close()
>>>

>>> import pymysql
>>> 
>>> con = pymysql.connect(host='localhost', user='guest', db='test', charset='utf8')
>>> cur = con.cursor()
>>> cur.execute('select * from cond')
17184
>>>

Python 3.4.2 (v3.4.2:ab2c023a9432, Oct  6 2014, 22:15:05) [MSC v.1600 32 bit (Intel)] on win32
Type "copyright", "credits" or "license()" for more information.
>>> import mysql.connector as connector
>>> connection = connector.connect(host="*****", database="*****", password="*****", user="*****")
>>> cursor = connection.cursor()
>>> cursor.execute("SELECT series_id FROM series WHERE status <> 'X'")
>>> rows = {r[0] for r in cursor}
Traceback (most recent call last):
  File "<pyshell#4>", line 1, in <module>
    rows = {r[0] for r in cursor}
  File "<pyshell#4>", line 1, in <setcomp>
    rows = {r[0] for r in cursor}
  File "C:\Program Files (x86)\Python\lib\site-packages\mysql\connector\cursor.py", line 809, in fetchone
    row, self.description)
  File "C:\Program Files (x86)\Python\lib\site-packages\mysql\connector\conversion.py", line 394, in row_to_python
    result[i] = self._cache_field_types[field_type](row[i], field)
  File "C:\Program Files (x86)\Python\lib\site-packages\mysql\connector\conversion.py", line 421, in _INT_to_python
    return int(value)
ValueError: invalid literal for int() with base 10: b'8783402\n\x00\x00\x00'
>>> 

Python 3.4.2 (v3.4.2:ab2c023a9432, Oct  6 2014, 22:15:05) [MSC v.1600 32 bit (Intel)] on win32
Type "copyright", "credits" or "license()" for more information.
>>> import mysql.connector as connector
>>> connection = connector.connect(host="*****", database="*****", password="*****", user="*****")
>>> cursor = connection.cursor()
>>> cursor.execute("SELECT series_id FROM series WHERE status <> 'X' LIMIT 1000")
>>> rows = {r[0] for r in cursor}
>>> len(rows)
1000

>>> int(b'1\x00', 10)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ValueError: invalid literal for int() with base 10: b'1\x00'
>>> int(b'\x00', 10)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ValueError: invalid literal for int() with base 10: b'\x00'
>>> int(b'1\n', 10)
1
>>>