On Wed, Dec 26, 2007 at 05:48:14PM -0800, ivan.hou wrote:
>
> XID is transcation ID?
Yes.
> so, "select * from mydb" is a transcation?
Yes.
> if i executed "select * from mydb" twice, the XID wil be increased by 2
Yep. Whereas if you did
BEGIN;
SELECT 1;
SELECT 1;
COMMIT;
the xid would be increased by 1.
A