steppefox/mysql_list_commands.md

## mysql_list_commands.md

      
    Raw
  

              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