def genSqlCmd(aid,limit=0, offset=0) :
sqlcmd = 'SELECT * FROM test where aid = ?"
if limit > 0:
offset = min( 0, offset )
sqlcmd = '%s LIMIT %d OFFSET %d'% (sqlcmd, limit, offset)
sqlObj.execute(sqlcmd,(aid
,))
limit都是傳50進去,而offset分成兩種傳法:
- 3000-->2950-->2900
- 0-->50-->100
No comments:
Post a Comment