One 、mysql advantage
1、 The cost is low ： Open source , Generally, you can try it for free , It's using gpl agreement
2、 High performance ： Fast execution
3、 Simple ： Easy to install and use
Two 、DBMS There are two kinds of ：
1、 Based on shared file system DBMS（Access）
2、 client-based -- The server （c/s) Of DBMS（mysql、oracle、sqlserver）
3、 ... and 、mysql Community version download address
Four 、 start-up 、 stop it mysql service
1、 start-up
Open as administrator cmd window , Input net start mysql
2、 stop it
Open as administrator cmd window , Input net stop mysql
Be careful ：MYSQL The default name during installation is “mysql”, If you change the name during installation , You need to enter the changed name
5、 ... and 、 Connect to database
1、 adopt cmd Connect
mysql -h Host name -P 3306 -u root -p123456
-h： Host name host（ You can input directly locally losthost）
-P： Port number
-u： user name
-p： password
notes ：-p And password cannot be preceded by spaces
6、 ... and 、mysql Grammatical features
1、 Case insensitive , But it is recommended that keywords be capitalized , Name 、 Table name in lowercase ;
2、 The end of the statement needs to be ; perhaps \g（ It is best to ;）;
3、 Each command can be shortened or wrapped as needed ;
4、 notes
Single-line comments ： # Note text
Single-line comments ： -- Note text
Multiline comment ： /* Note text */
7、 ... and 、DQL、DDL、DML、TCL、DCL
DQL： Data query language
Query statement
DDL： Data definition language
Library table creation 、 Delete
DML： Data operation language
Insert statement
Delete statements
Modify the statement
TCL： Things control language
Transactions and transactions
DCL： Permission control language
