MySQL - Inserting multiple records at the same time.

[EFileTahi-A]

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?

 

[penfold69]

Using the Mysql Connector.Net, you should be able to issue multiple commands within one SQL statement.

B.

 

[EFileTahi-A]

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

 

[kejpa]

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

 

[EFileTahi-A]

Pheewww.... Thank you once more Kejpa . That was really nice to hear

 

[Nerseus]

I read on their main page that they handle ACID since version 3.x (cant recall). That means that one user shouldnt 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

 

[EFileTahi-A]

Ok Nerseus, thank you for the info