Search Results for

    Show / Hide Table of Contents

    Enum LockContention

    Defines waiting options that may be used with row locking options.

    Namespace: MySql.Data.MySqlClient
    Assembly: MySql.Data.dll
    Version: 9.3.0
    Syntax
    public enum LockContention

    Fields

    Name Description
    Default

    Waits until the blocking transaction releases the row lock.

    NoWait

    Never waits to acquire a row lock. The query executes immediately, failing with an error if a requested row is locked.

    SkipLocked

    Never waits to acquire a row lock. The query executes immediately, removing locked rows from the result set.

    In This Article
    • Fields
    Back to top Copyright © 2021, 2025, Oracle and/or its affiliates.