Database Fundamentals Article 2 (MySQL)

2.1MySQL Getting Started

1) Download to mysql website.

2) Install mysql software

3) Use

Verify success

turn on cmd-- input mysql-u root-p Enter password return

C:\users\apple>mysql-u root-p

Enter Password: * * *

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 2

Server version:5.5.40 MySQL Community Server (GPL)

Copyright (c), the Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its

Affiliates. Other names trademarks of their respective

Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql>

3 MySQL database 3.1 mysql data storage structure

First the database, then the table, then the data

Database Fundamentals Article 2 (MySQL)