Fetch Only new data from auto-updating online sql database

2018-06-05 08:29:22

I have an online MySQL (presto) database which keeps on auto-updating (i.e., new rows keep getting added to the tables(views, to be exact) every day). I want to fetch the data from it every day but don't want to refetch the data that I have already fetched before.

I am using python3 for extracting the data from the online host database as:

from pyhive import presto

import numpy as np

cursor=presto.connect().cursor()

sql = 'select * from schema.table'

cursor.execute(sql)

rows = np.array(cursor.fetchall())

cursor.close()

Doing this takes time and fetches all the data (new data as well as already fetched data). I am storing the data in rows variable in a csv file afterward.

Is there any way to get only the new data (id is the primary key in the table)?

Thanks in advance.