Mysql Commands

Show process list:

SHOW PROCESSLIST;

asd

 Properties of Transactions:

Transactions have the following four standard properties, usually referred to by the acronym ACID:

 Atomicity: ensures that all operations within the work unit are completed successfully; otherwise, the transaction is aborted at the point of failure, and previous operations are rolled back to their former state.

 Consistency: ensures that the database properly changes states upon a successfully committed transaction.

 Isolation: enables transactions to operate independently of and transparent to each other.

 Durability: ensures that the result or effect of a committed transaction persists in case of a system failure.

In MySQL, transactions begin with the statement BEGIN WORK and end with either a COMMIT or a ROLLBACK statement. The SQL commands between the beginning and ending statements form the bulk of the transaction.

http://www.tutorialspoint.com/mysql/mysql-transactions.htm

cat >> ~/.bashrc << EOF
alias mysql="mysql –pager='less -niSFX'"
EOF