Perl and database is Mysql.

Hi,


Assume user1 does his activity as given below.
While user-1 completed step-2, user-2 does this activity as given below.

Doubts:
(1). Will user-2 get a chance to
insert in to 'common_table' while the db connection is still kept open by user-1.

(2). If (1) given above is true then how to make sure that certain table is not accessible by other users (for example user-2) while a user is operating on it.

Activity of user-1:
#Step-1 Open database using DBI->connect

#Step-2 SELECT few rows from table called 'common_table' do some operation

#Step-3 Based on selection in step-2 INSERT INTO common_table

#Step-4 Close database using $dbh->disconnect;

Activity of user-2
#Step-1 Open database using DBI->connect

#Step-2 INSERT more columns to 'common_table'

#Step-3 Close database using $dbh->disconnect;


~Thanks