upper/db

exists used count(1)

wzhsh90 opened this issue · 0 comments

wzhsh90 commented

SELECT count(1) AS _t FROM person_info_t WHERE (id=?) LIMIT 1

why not use

SELECT 1 AS _t FROM person_info_t WHERE (id=?) LIMIT 1