1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Rep Power
    I used to write CGI program that insert data into files. What I used to do was open the file, lock it, write to it, and then unlock it. If another user tries to insert something into the file while it's locked then tough luck. That's why I wrote a loop that would try writing to file a few times before quiting.

    With MySql, I am inserting and updating data to the same database, but I have no idea how to resolve multiple users conflict. Is that done automatically?

    What happens if two or more users try to insert into the database at the same time? What happens if they try to update a record at the same time?

    Thank you.
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    i believe that mysql actions occur simultaneously, meaning that many users can be inserting data at the same time without a problem, and in the case of an update, the last action is the one that is stored

Similar Threads

  1. Pointer problem in opening a file
    By LAKI in forum C Programming
    Replies: 13
    Last Post: February 11th, 2004, 08:27 AM
  2. Pointer problems opening file *formatted*
    By LAKI in forum C Programming
    Replies: 4
    Last Post: February 11th, 2004, 06:06 AM
  3. Reading from a database file to an ArrayList
    By rbutturini in forum .Net Development
    Replies: 0
    Last Post: February 6th, 2004, 11:53 PM
  4. PHP file upload script trouble
    By casbboy in forum PHP Development
    Replies: 9
    Last Post: February 5th, 2004, 07:42 PM
  5. Simple find and replace word search for a text file with php?
    By rabid lemming in forum PHP Development
    Replies: 4
    Last Post: February 1st, 2004, 09:37 PM

IMN logo majestic logo threadwatch logo seochat tools logo