Professional Web Applications Themes

locking tables - MySQL

If I lock a table with write, will another connection be able to read from that table while it's locked? I hope not....

Sponsored Links
  1. #1

    Default locking tables

    If I lock a table with write, will another connection be able to read from
    that table while it's locked? I hope not.


    Sponsored Links
    Jim Michaels Guest

  2. #2

    Default Re: locking tables


    "Jim Michaels" <NOSPAMFORjmichae3> wrote in message
    news:uo6dnTOfVoLP2tHZnZ2dnUVZ_t6dnZ2dcomcast.com. ..
    > If I lock a table with write, will another connection be able to read from
    > that table while it's locked? I hope not.
    >
    I just tried it, I think reads are allowed. ugh. this race condition is
    causing grief. Am I technically wrong? I couldn't find anything specific
    about this situation in the manual (unfortunately). and there's no way to
    lock a table for both read AND write.


    Jim Michaels Guest

Similar Threads

  1. Nested tables, locking it down.
    By Captain Ru in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 3rd, 09:27 PM
  2. Need Help with Locking
    By CFRAM in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: July 28th, 03:16 AM
  3. DB2 locking UDF dll
    By W Gemini in forum IBM DB2
    Replies: 2
    Last Post: August 7th, 03:23 AM
  4. Locking File
    By Ron Vecchi in forum ASP.NET General
    Replies: 2
    Last Post: July 23rd, 07:40 PM
  5. Locking cell and tables
    By Dan Vendel *GOF* in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 17th, 06:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139