MySQL Database basic operations

#分两大类: Relational: As Sqllite,db2,oracle,access,sql server,mysql, NOTE: SQL statements are generic non-relational: mongodb,redis,memcache# can be simply understood as:    Relational database requires a table structure    non-relational database is key-value stored, no table structure

Database Classification

#1, download: MySQL Community Server5.7. -http://Dev.mysql.com/Downloads/Mysql/#2, decompression If you want MySQL to be installed in the specified directory, then move the extracted folder to the specified directory, such as: C:\mysql-5.7. --winx64#3, add environment variable "right-click Computer"--" Attribute"-"Advanced system Settings"-"Advanced"-"Environment variable"-"in the Second content box find the variable named path of a row, double-click"-"to append the MySQL bin directory path to the variable value, use; split" #4, initialize mysqld--initialize-insecure#5, start MySQL service mysqld # start MySQL Service #6, start MySQL client and connect MySQL service MySQL-U root-P # Connect to MySQL server

Windows installation

The last step solves some problems, but is not thorough enough, because the current terminal will be stuck while executing "MYSQD" to start the MySQL server, then do the setup to resolve this problem: note:--the absolute path of the command must be started with MySQL before install# make MySQL Windows service, execute this command at Terminal: "C:\mysql-5.7. --Winx64\bin\mysqld "--Install# To remove the MySQL Windows service, execute this command at the terminal: "C:\mysql-5.7. --Winx64\bin\mysqld "--Removeafter registering as a service, when you start and close the MySQL service later, you only need to execute the following command: # start MySQL service net start MySQL # close MySQL service net stop MySQL

MySQL made Windows services

MySQL Database basic operations