MySQL list of commands

mysql_list_commands.md

**** Show current processes ****

SHOW FULL PROCESSLIST;

Add column

ALTER TABLE table_name ADD column_name VARCHAR(60) AFTER name;

Truncate table

TRUNCATE TABLE table_name;

Get all information about table

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

Mysqldump

mysqldump --single-transaction -uusername -p base>dump.sql