tablename = ['t_acq_data_20180901','t_acq_data_20180902']
curtable=tablename[0]
sql = "SELECT SHIP_ID,LONGITUDE,LATITUDE,SPEED,TACK,CREATE_TIME From " +curtable + " WHERE SHIP_ID='35512'"
cursor.execute(sql)
results = cursor.fetchall()
python SQL语句变量拼接
最新推荐文章于 2022-12-05 09:36:42 发布