Home > Database > Mysql Tutorial > 【MySQL】如何在phpMyAdmin中增加innoDB,并新建外键ForeignKey_MySQL

【MySQL】如何在phpMyAdmin中增加innoDB,并新建外键ForeignKey_MySQL

WBOY
Release: 2016-06-01 13:17:29
Original
992 people have browsed it

phpmyadminMysql外键

如何在phpMyAdmin中增加innoDB

使用phpNow(Win32下绿色免费的Apache+PHP+MySQL环境套件包)发现默认不支持innoDB引擎的数据库,尝试了网上很多方法,发下如下方法有效,记录下来供大家参考:

/

1,修改my.ini

在phpNow的工具MySQL目录(如.../PHPnow-1.5.6/MySQL-5.0.90)中找到my.ini, 搜索skip-innodb,搜索到之后,将其注释掉(#skip-innodb),注意网上有人说还要将下面以innoDB开头对去掉注释,使其生效,我这边尝试的结果是,除过上面提到的skip-innodb不需要做其他动作。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template