Shulou(Shulou.com)06/01 Report--

This article mainly shows you "how to display, delete, modify and select databases in MySQL". The content is simple and easy to understand, and the organization is clear. I hope it can help you solve your doubts. Let Xiaobian lead you to study and learn "how to display, delete, modify and select databases in MySQL".

1. delete database

mysql> drop database stu;

If the deleted database does not exist, an error will be reported. The solution is to judge before deleting, and delete if it exists.

mysql> drop database if exists stu; Query OK, 0 rows affected (0.00 sec)

2. Show statements that create databases

Syntax: show create database name

mysql> show create database yudb;

+----------+--------------------------------------------------------------+

| Database | Create Database

+----------+--------------------------------------------------------------+

| yudb | CREATE DATABASE `yudb` /*! 40100 DEFAULT CHARACTER SET gbk */

+----------+--------------------------------------------------------------+

3. Modify database character encoding

Syntax: alter database database name charset= character encoding;

mysql> alter database yudb charset=utf8; Query OK, 1 row affected (0.00 sec)

4. select database

Syntax: use database name

mysql> use yudb; Database changed The above is "How to display, delete, modify and select databases in MySQL" All the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.