EFileTahi-A Posted September 21, 2005 Posted September 21, 2005 With Access databases an error would occur when trying to write 2 or more records in a table of the Database at the same time. Will this happen in MySQL too? Quote
penfold69 Posted September 21, 2005 Posted September 21, 2005 Using the Mysql Connector.Net, you should be able to issue multiple commands within one SQL statement. B. Quote
EFileTahi-A Posted September 23, 2005 Author Posted September 23, 2005 Argh! I expressed myself truly badly... I meant insert multiple records from multiple computers in the same DataBase in the same Table at the same time... Sorry :D Quote
kejpa Posted September 23, 2005 Posted September 23, 2005 No, there should be no problems of doing that. AFAIK is mySQL designed to be a multiuser database engine just like SQL server and unlike Access. /Kejpa Quote
EFileTahi-A Posted September 23, 2005 Author Posted September 23, 2005 Pheewww.... Thank you once more Kejpa :). That was really nice to hear ;) Quote
*Experts* Nerseus Posted September 24, 2005 *Experts* Posted September 24, 2005 I read on their main page that they handle ACID since version 3.x (can't recall). That means that one user shouldn't have an issue with another user, and you can be guaranteed that a set of inserts or updates can commit as one unit, if you want. -ner Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
EFileTahi-A Posted October 4, 2005 Author Posted October 4, 2005 Ok Nerseus, thank you for the info :) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.