[摘要]+----------------------------------+--------+4 rows in set, 1 warning (0.00 sec)InnoDB 为默认引擎修改默认引擎m...
+----------------------------------+--------+
4 rows in set, 1 warning (0.00 sec)
InnoDB 为默认引擎
修改默认引擎
my.ini文件
[mysqld]
# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory
# shared-memory-base-name=MYSQL
# The Pipe the MySQL Server will use
# socket=MYSQL
# The TCP/IP Port the MySQL Server will listen on 默认端口号
port=3306
# Path to installation directory. All paths are usually resolved relative to this. 服务器的默认安装目录
# basedir="C:/Program Files/MySQL/MySQL Server 5.7/"
# Path to the database root 数据库数据文件的目录
datadir=C:/ProgramData/MySQL/MySQL Server 5.7\Data
# The default character set that will be used when a new schema or table is
# created and no character set is defined 修改服务器默认字符
character-set-server=utf8
# The default storage engine that will be used when create new tables when
# 这里修改默认引擎
default-storage-engine=INNODB
修改后重启Mysql服务
以上就是mysql学习之数据引擎的示例代码分享的详细内容，更多请关注php中文网其它相关文章！
学习教程快速掌握从入门到精通的SQL知识。
关键词：mysql学习之数据引擎的示例代码分享