Installation and use of MySQL tutorial

MySQL tutorial on installation and use

First, MySQL the download and installation

First login to MySQL's official website, choose Downloads→windows→mysql installer→windows (x86,32-bit), MSI Installer

At the time of installation, you may want to download the. NET Framework, download it directly, and then install it in one step.

Second, MySQL tutorial on using

(1) Login to MySQL via DOS

C:\>c:

C:\>CD program Files

C:\> program FILES>CD MySQL

C:\> program files> MYSQL>CD MySQL Server 5.7

C:\> program files> mysql> MySQL Server 5.7>cd Bin

C:\> program files> mysql> MySQL Server 5.7> bin> mysql–uroot–p123456

(2) Create a database

Create DATABASE name

(3) Select the desired database

Use database name

(4) Create a database table

CREATE TABLE Table name

(5) Inserting data into the table

insert into table name [(column name 1, column Name 2, ...)] VALUES (value 1, value 2, ...)

(6) Querying the data in a table

Select Column name from table name

Installation and use of MySQL tutorial