MySQL Forums
Forum List  »  Security

Session Management
Posted by: Paul Mackinlay
Date: June 02, 2006 03:06AM

I would like to know more about how session management works with mysql.

If I have a .sql batch file (example.sql) that I am running as user paul:
mysql -u paul mydatabase < example.sql
and it causes an error. Can I attempt a rollback by using:
mysql -u paul -e "ROLLBACK" mydatabase
Will that issue a rollback in a seperate session belonging to the same user or the same session?

I guess I need to know if each user only ever has one single session.

Options: ReplyQuote


Subject
Views
Written By
Posted
Session Management
3685
June 02, 2006 03:06AM
2177
June 02, 2006 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.