MySQL useful commands/queries

1. TRIGGER privileges:

In order to assign this privilege to an user you must run this SQL query while you are logged with a user who has permission to GRANT:
                GRANT TRIGGER ON [dbname].* TO '[username]'@'[hostname]'
To Grant Trigger privileges on all databases for user root while this user is connected from any host, you should use this SQL query:
                GRANT TRIGGER ON *.* TO 'root'@'%'

2. UPDATE table information:

UPDATE `database_name`.`table_name` SET `table_field1`='a', `table_field2`='b' WHERE `table_field3`='c';

Useful link: 

- http://www.pantz.org/software/mysql/mysqlcommands.html