2.数据库的基本操作<针对于库层面的操作>
2024-09-01 06:00:18
1.查看已有数据库：
MySQL [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_test |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.04 sec)
2.创建数据库：
MySQL [(none)]> create database database_name;
Query OK, 1 row affected (0.04 sec)
3.数据库创建完后可以使用show create database 申明查看数据库的定义：
MySQL [(none)]> show create database database_name\G;
+---------------+------------------------------------------------------------------------+
| Database | Create Database |
+---------------+------------------------------------------------------------------------+
| database_name | CREATE DATABASE `database_name` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+---------------+------------------------------------------------------------------------+
1 row in set (0.04 sec)
4.删除数据库：
MySQL [(none)]> drop database database_name;
Query OK, 0 rows affected (0.09 sec)
5.查看MySQL存储引擎：
MySQL [(none)]> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.04 sec)
6.MySQL库表授权：
MySQL 赋予用户权限命令的简单格式可概括为： grant [权限] on [数据库对象] to [用户] < exp: grant select, insert, update, delete on testdb.* to common_user@'%' >
具体可参见文档：
最新文章
- Android 手机卫士2--home页面
- 基础拾掇之——http基础
- MongoDB资料汇总
- 重启Tomcat的脚本
- 从零开始学ios开发（六）：IOS控件（3），Segmented Control、Switch
- jQuery数组处理
- Struts 2 Tutorials
- Java集合和PHP的对比
- FPGA知识大梳理（四）FPGA中的复位系统大汇总
- 深度探索C++对象模型之C++对象模型笔记
- 关于JAVA中hashCode
- 用JavaScript按一定格式解析出URL 串中所有的参数
- path sum II（深度优先的递归实现掌握）
- 彻底搞懂spark的shuffle过程（shuffle write）
- SQLAlchemy+Flask-RESTful使用(四)
- js数据结构与算法——字典与散列表
- 解决微信小程序的wx-charts插件tab切换时的显示会出现位置移动问题-tab切换时，图表显示错乱-实现滑动tab
- Saddle Point ZOJ - 3955（求每个值得贡献）
- JIRA python篇之展示多人未完成任务列表
- Redis工业生产应用场景