當前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

MySQL（一）基础操作

發布時間：2023/12/2 数据库 29 豆豆

生活随笔收集整理的這篇文章主要介紹了 MySQL（一）基础操作小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

MySQL基礎操作

一、MySQL數據庫管理

1.登入

mysql -u root -p

然后輸入密碼

2.查看當前MySQL會話使用的字符集

show variables like 'character%';

顯示如下：

?mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name??????????? | Value?????????????????????????????????????????????????? |
+--------------------------+---------------------------------------------------------+
| character_set_client???? | utf8??????????????????????????????????????????????????? |
| character_set_connection | utf8??????????????????????????????????????????????????? |
| character_set_database?? | utf8??????????????????????????????????????????????????? |
| character_set_filesystem | binary????????????????????????????????????????????????? |
| character_set_results??? | utf8??????????????????????????????????????????????????? |
| character_set_server???? | utf8??????????????????????????????????????????????????? |
| character_set_system???? | utf8??????????????????????????????????????????????????? |
| character_sets_dir?????? | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.10 sec)

3.創建數據庫

create database database_name;

create database choose;

顯示如下：

mysql> create database database_name;
Query OK, 1 row affected (0.08 sec)

mysql> create database choose;
Query OK, 1 row affected (0.00 sec)

4.查看數據庫

show databases;

顯示如下：

5.顯示數據庫結構

show create database_name;

例如show create choose;

顯示如下：

mysql> show create database choose;
+----------+-----------------------------------------------------------------+
| Database | Create Database???????????????????????????????????????????????? |
+----------+-----------------------------------------------------------------+
| choose?? | CREATE DATABASE `choose` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-----------------------------------------------------------------+
1 row in set (0.00 sec)

6.選擇當前操作的數據庫

use database_name;

顯示如下：

mysql> use database_name;
Database changed

7.刪除數據庫

drop database database_name;

顯示如下：

mysql> drop database database_name;
Query OK, 0 rows affected (0.08 sec)

二、MySQL表管理

1.查看MySQL服務實例支持的存儲引擎

show engines;

顯示如下：

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine???????????? | Support | Comment??????????????????????????????????????????????????????? | Transactions | XA?? | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| FEDERATED????????? | NO????? | Federated MySQL storage engine???????????????????????????????? | NULL???????? | NULL | NULL?????? |
| MRG_MYISAM???????? | YES???? | Collection of identical MyISAM tables????????????????????????? | NO?????????? | NO?? | NO???????? |
| MyISAM???????????? | YES???? | MyISAM storage engine????????????????????????????????????????? | NO?????????? | NO?? | NO???????? |
| BLACKHOLE????????? | YES???? | /dev/null storage engine (anything you write to it disappears) | NO?????????? | NO?? | NO???????? |
| CSV??????????????? | YES???? | CSV storage engine???????????????????????????????????????????? | NO?????????? | NO?? | NO???????? |
| MEMORY???????????? | YES???? | Hash based, stored in memory, useful for temporary tables????? | NO?????????? | NO?? | NO???????? |
| ARCHIVE??????????? | YES???? | Archive storage engine???????????????????????????????????????? | NO?????????? | NO?? | NO???????? |
| InnoDB???????????? | DEFAULT | Supports transactions, row-level locking, and foreign keys???? | YES????????? | YES? | YES??????? |
| PERFORMANCE_SCHEMA | YES???? | Performance Schema???????????????????????????????????????????? | NO?????????? | NO?? | NO???????? |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.05 sec)

2.創建數據庫表my_table

mysql> use choose;
Database changed
mysql> set default_storage_engine=InnoDB;
Query OK, 0 rows affected (0.02 sec)

mysql> create table my_table(
??? -> today datetime,
??? -> name char(20)
??? -> );
Query OK, 0 rows affected (0.18 sec)

轉載于:https://www.cnblogs.com/zhying99/p/9699640.html

總結

以上是生活随笔為你收集整理的MySQL（一）基础操作的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。