import pymysql
hid='26de2902-8c28-4ba9-97d4-167609043fcc'
conn=pymysql.connect(host='218.93.191.20',port=3306,user='read_only_jiansun',password='^9B%@iQJESZrR!',db='jiansunblueprint',charset='utf8mb4',autocommit=True)
cur=conn.cursor()
cur.execute('select id,hid,url,orderNum from missiontask_instructions where hid=%s order by orderNum asc limit 10',(hid,))
rows=cur.fetchall()
print('instructions',len(rows))
for r in rows:
    print(r)
cur.execute('select id,hid,url,orderNum,videoId from missiontask_video where hid=%s order by orderNum asc limit 10',(hid,))
rows=cur.fetchall()
print('video',len(rows))
for r in rows:
    print(r)
cur.close();conn.close()