当前位置：网站首页>MySQL view database and table creation statements

MySQL view database and table creation statements

2022-04-22 11:07:00 【a10534126】

Sometimes we need to check mysql Create table statement of , The following is the specific operation

Look at the database creation statement

SHOW CREATE DATABASE ZOOG;

Similar view table creation statements ：

View all storage engines ：SHOW ENGINES G;

View the default storage engine :SHOW VARIABLES LIKE ‘storage_engine’;

Check the database currently in use :SELECT DATABASE();

Or use the command ：STATUS

win Modify the default storage engine under , file found my.ini, take [mysqld] Below the field default-storage-engine The value after the parameter , from “InnoDB” Change it to “MyISAM”, Save the file and restart MySQL that will do .

版权声明
本文为[a10534126]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221103070746.html

边栏推荐

猜你喜欢

随机推荐