Getting started with MySQL

One: How to test if the installation is successful?

1. Add the MySQL bin path to the system environment variable path.

2.Window + R Open Run input cmd-input mysql-u root-p return

Enter Password: ****** carriage return/* Enter the password set up during installation */

The following code appears to indicate that the installation was successful

Welcome toThe MySQL Monitor. CommandsEnd  with;or\g.your MySQL Connection ID is 2Server Version:5.5. +MySQL Community Server (GPL) Copyright (c) -, the, Oracleand/orits affiliates. Allrights reserved. Oracle isA registered trademark ofOracle Corporationand/oritsaffiliates. Names may trademarks oftheir respectiveowners. Type'Help ;' or '\h'  forHelp. Type'\c'  toClear the Currentinput Statement.mysql>

II: MySQL Database

1.mysql Data storage structure

First the database, then the table, then the data

　　　

2.SQL

SQL (Structure query lanuage, Structured Query Language) Language: the language that interacts with the database, and the language of database management.

The role of SQL statements

(1) Management data Sheet

　　　　(2) Management table

　　　　(3) Managing Data

Enter Password: * * *

Getting started with MySQL