Re: What's the XID?

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