擅长:python、mysql、java
<p>你可以这样试试</p>
<pre><code> while number < 10 :
query = 'SELECT * FROM BADGE_UNIQUEID WHERE BADGEID LIKEe '+ "'"+ str(number)+"%'"
try:
cur.execute(query)
print(cur.fetchall()[0])
except:
print("it was none")
number += 1
</code></pre>