Mac上做java开发（一）：​安装mysql

brew install mysql

mysql.server start

mysql_secure_installation

mysql -u root -p

// 创建数据库firstDB：
mysql> create database firstDB;
Query OK, 1 row affected (0.01 sec)mysql> create database firstDB;
Query OK, 1 row affected (0.01 sec)

// 查看所有数据库：
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| firstDB            |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

// 进入firstDB数据库：
mysql> use firstDB;
Database changedmysql> use firstDB;
Database changed

// 创建表格user
mysql> create table user(id int primary key auto_increment,
    -> username varchar(32) unique not null,
    -> password varchar(32) not null);
Query OK, 0 rows affected (0.02 sec)

// 查看firstDB中的所有表格：
mysql> show tables;
+-------------------+
| Tables_in_firstdb |
+-------------------+
| user              |
+-------------------+
1 row in set (0.00 sec)

// 查看表格属性信息：
mysql> desc user
    -> ;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(11)     | NO   | PRI | NULL    | auto_increment |
| username | varchar(32) | NO   | UNI | NULL    |                |
| password | varchar(32) | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

// 表格中插入数据：
mysql> insert into user values(1,'Jesse','jesse');
Query OK, 1 row affected (0.00 sec)

// 查看表格中的数据：
mysql> select * frome user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'frome user' at line 1
mysql> select * from user;
+----+----------+----------+
| id | username | password |
+----+----------+----------+
|  1 | Jesse    | jesse    |
+----+----------+----------+
1 row in set (0.00 sec)

mysql>