Welcome to the MySQL monitor. Commands endwith;or \g.
Your MySQL connection id is8
Server version: 8.0.15 MySQL Community Server - GPL
Copyright (c)2000,2019, Oracle and/or its affiliates.All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type'help;'or'\h'for help.Type'\c'to clear the current input statement.
我们来看一下数据库的编码格式. show create database 数据库名称。毕竟我们要展示创建的数据库,所以create 怎么能少?咦,我怎么没在下边看见编码格式呢?嘿嘿,仔细看看,它躲在注释里呢!
mysql>showcreatedatabase newAginData;+-------------+----------------------------------------------------------------------+|Database|CreateDatabase|+-------------+----------------------------------------------------------------------+| newAginData |CREATEDATABASE`newAginData`/*!40100 DEFAULT CHARACTER SET utf8 */|+-------------+----------------------------------------------------------------------+1rowinset(0.00 sec)
如果我新建数据库时没有写编码形式,会是啥?当然会是MySQL默认的编码格式。这取决于你安装数据库是的操作!接下来,我们看看如何修改数据库编码格式:alter database 数据库名 character set 编码形式;