生活随笔
收集整理的這篇文章主要介紹了
mysql表引擎修改
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
1、修改建表引擎
[sql]?view?plaincopyprint? ?mysql>?CREATE?TABLE?test_2(?? ?????->?name?varchar(10),?? ?????->?year?int(10))?? ?????->?ENGINE=InnoDB;????????????-->創建表時指定默認引擎??? ?Query?OK,?0?rows?affected?(0.10?sec)?? ??? ?mysql>?show?create?table?test_2\G?? ?***************************?1.?row?***************************?? ????????Table:?test_2?? ?Create?Table:?CREATE?TABLE?`test_2`?(?? ???`name`?varchar(10)?DEFAULT?NULL,?? ???`year`?int(10)?DEFAULT?NULL?? ?)?ENGINE=InnoDB?DEFAULT?CHARSET=latin1?? ?1?row?in?set?(0.00?sec)?? ??? ?mysql>?? ??? ??? ?mysql>?show?tables;?? ?+------------------+??? ?|?Tables_in_excise?|?? ?+------------------+??? ?|?test1????????????|?? ?|?test_1???????????|?? ?+------------------+??? ?2?rows?in?set?(0.00?sec)?? ??? ?mysql>?show?create?table?test_1\G?? ?***************************?1.?row?***************************?? ????????Table:?test_1?? ?Create?Table:?CREATE?TABLE?`test_1`?(?? ???`name`?varchar(20)?DEFAULT?NULL,?? ???`year`?int(5)?DEFAULT?NULL?? ?)?ENGINE=MyISAM?DEFAULT?CHARSET=latin1?????-->?默認的表引擎為MyISAM;??? ?1?row?in?set?(0.00?sec)?? ??? ?mysql>?alter?table?test_1?type=InnoDB;??-->??修改表的數據引擎;??? ?Query?OK,?0?rows?affected,?1?warning?(0.11?sec)?? ?Records:?0??Duplicates:?0??Warnings:?0?? ??? ?mysql>?show?create?table?test_1\G?? ?***************************?1.?row?***************************?? ????????Table:?test_1?? ?Create?Table:?CREATE?TABLE?`test_1`?(?? ???`name`?varchar(20)?DEFAULT?NULL,?? ???`year`?int(5)?DEFAULT?NULL?? ?)?ENGINE=InnoDB?DEFAULT?CHARSET=latin1??-->?顯示表的數據引擎已經變為InnoDB;??? ?1?row?in?set?(0.00?sec)?? ??? ?mysql>? 2.
[sql]?view?plaincopyprint? ?mysql>?show?engines;???-->??查看MySQL支持引擎?????? ?+------------+---------+------------------------------------------------------------+--------------+------+------------+??? ?|?Engine?????|?Support?|?Comment????????????????????????????????????????????????????|?Transactions?|?XA???|?Savepoints?|?? ?+------------+---------+------------------------------------------------------------+--------------+------+------------+??? ?|?MRG_MYISAM?|?YES?????|?Collection?of?identical?MyISAM?tables??????????????????????|?NO???????????|?NO???|?NO?????????|?? ?|?CSV????????|?YES?????|?CSV?storage?engine?????????????????????????????????????????|?NO???????????|?NO???|?NO?????????|?? ?|?MyISAM?????|?DEFAULT?|?Default?engine?as?of?MySQL?3.23?with?great?performance?????|?NO???????????|?NO???|?NO?????????|?? ?|?InnoDB?????|?YES?????|?Supports?transactions,?row-level?locking,?and?foreign?keys?|?YES??????????|?YES??|?YES????????|?? ?|?MEMORY?????|?YES?????|?Hash?based,?stored?in?memory,?useful?for?temporary?tables??|?NO???????????|?NO???|?NO?????????|?? ?+------------+---------+------------------------------------------------------------+--------------+------+------------+??? ?5?rows?in?set?(0.00?sec)?? ??? ?mysql>? ?
轉載于:https://blog.51cto.com/kumu1988/1086235
總結
以上是生活随笔為你收集整理的mysql表引擎修改的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
