数据库 基础篇2（mysql）

2.1MySQL入门

1）到mysql官网下载。

2）安装mysql软件

3）使用

验证是否成功

打开cmd  -> 输入 mysql -u root -p  回车   -> 输入密码   回车

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) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

 

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

affiliates. Other names may be trademarks of their respective

owners.

 

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

 

mysql>

3 MySQL数据库

3.1 mysql数据存储结构

先数据库，再表，再有数据