adini121/Useful_mysql_commands.md

## Useful_mysql_commands.md

      
    Raw
  

              Useful_mysql_commands.md
            
          
    ##(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 permissions

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'password';
All about tables

Describe all details about table

DESCRIBE name_of_table;
Dump mysql single 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