##(My)sql commands I encountered throughout my sql-experience
####Basics #####Create database and tables
DROP DATABASE IF EXISTS database_name;
CREATE DATABASE database_name DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'password';
DESCRIBE name_of_table;
To export
mysqldump -u -p database_name table_name > /path/to/file/table_name.sql
To import
mysql -u -p database < /path/to/file/table_name.sql