简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

MyISAM和外键支持_MySQL

WBOY
Release： 2016-06-01 14:01:17
Original
1003 people have browsed it

问：MySQL中的MyISAM是否支持外键约束？我创建了一个InnoDB的表，并声明了外键，现在我想把它转换成MyISAM。这是否是可行的？如果可以的话，我该怎么做呢？

　　答：外键约束位于MyISAM handler新增特性的to-do列表中，它们还没有被实现，并且可能还要持续一段时间。与此同时，您会发现InnoDB是实现大多数目的的一种良好的表handler。但是，如果您一定要将表转换成MyISAM，您将会失去执行外键的能力。想要将表转换为另一种handler，您可以使用如下语法：

　　ALTER TABLE 表名 TYPE= MyISAM

Related labels：
中
source：php.cn
Previous article：MySQL中InnoDB和MyISAM类型的差别_MySQL Next article：从MySQL 5.5发布看开源数据库新模式_MySQL
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1623
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
1779
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1516
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1426
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1471
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！