MySQL 基本操作

MySQL 基本操作

1.创建数据库

mysql> create database school;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| school             |
| sys                |
| world              |
+--------------------+

2.删除数据库

mysql> drop database school;
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| world              |
+--------------------+
6 rows in set (0.00 sec)

3.选择数据库

mysql> create database school;
Query OK, 1 row affected (0.01 sec)

mysql> use school;
Database changed

4.创建表对象（以及打印)//插入

mysql> create database school;
Query OK, 1 row affected (0.01 sec)

mysql> use school;
Database changed
mysql> create table class(class_ID int,class_name varchar(128),class_teacher varchar(64));
Query OK, 0 rows affected (0.03 sec)

mysql> insert into class values(1,'火箭一班','赵老师');
Query OK, 1 row affected (0.01 sec)

mysql> insert into class values(2,'火箭二班','李老师');
Query OK, 1 row affected (0.01 sec)

mysql> select*from class;
+----------+------------+---------------+
| class_ID | class_name | class_teacher |
+----------+------------+---------------+
|        1 | 火箭一班   | 赵老师        |
|        2 | 火箭二班   | 李老师        |
+----------+------------+---------------+
2 rows in set (0.00 sec)

5.打印另类用法

mysql> desc class;//命名规则
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| class_ID      | int          | YES  |     | NULL    |       |
| class_name    | varchar(128) | YES  |     | NULL    |       |
| class_teacher | varchar(64)  | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select class_ID from class;
+----------+
| class_ID |
+----------+
|        1 |
|        2 |
+----------+
2 rows in set (0.00 sec)

mysql> select class_name from class;
+------------+
| class_name |
+------------+
| 火箭一班   |
| 火箭二班   |
+------------+
2 rows in set (0.00 sec)

mysql> select class_ID,class_name from class;
+----------+------------+
| class_ID | class_name |
+----------+------------+
|        1 | 火箭一班   |
|        2 | 火箭二班   |
+----------+------------+
2 rows in set (0.00 sec)
mysql> select class_teacher from class where class_ID=1;
+---------------+
| class_teacher |
+---------------+
| 赵老师        |
+---------------+
1 row in set (0.00 sec)
mysql> select class_teacher from class where class_name='火箭一班';
+---------------+
| class_teacher |
+---------------+
| 赵老师        |
+---------------+
1 row in set (0.00 sec)