> Sent: Wednesday, September 27, 2006 10:45 PM
> To: Henda Carvalho
> Cc: mysql@lists.mysql.com
> Subject: Re: [mysql]Concurrency with inserts
>
> In the last episode (Sep 28), Henda Carvalho said:
> > One more question,
> >
> > What kind of tables does mysql create by
In the last episode (Sep 28), Henda Carvalho said:
> One more question,
>
> What kind of tables does mysql create by default? innodb or myisam?
The default is myisam.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
One more question,
What kind of tables does mysql create by default? innodb or myisam?
Best regards
Henda
On 9/27/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Sep 27), Henda Carvalho said:
> The links that you gave me doesn't say what is suposed to happen if 2
> different us
In the last episode (Sep 27), Henda Carvalho said:
> The links that you gave me doesn't say what is suposed to happen if 2
> different users are trying to make an insert (using the insert
> statement) to the same table.
>
> Will the transaction abort for one of the users?
No; they will both proce
In the last episode (Sep 27), Henda Carvalho said:
> Can somebody please tell me what is the behaviour of mysql when 2
> different users are trying to make an insert to the same table.
http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
http://dev.mysql.com/doc/refman/5.0/en/concurrent-inser