List queries currenty running

SHOW processlist

Add column

ALTER TABLE <table> ADD COLUMN <column> <type> <extra parameter>

eg :

ALTER TABLE offer ADD COLUMN is_sent BOOLEAN DEFAULT NULL

Get MySQL version

SELECT version()

List locked table on MySQL

SHOW OPEN tables WHERE in_use > 1

Kill query currently in process

First, show all query in process

SHOW processlist

Then get the id, and use the following query to stop your query

KILL QUERY <id>

Get engine used by table on MySQL

SHOW TABLE status FROM <database> LIKE 'table_name'
``