adspace


How to change the database engine in mysql?

Answer Posted / Arti Kumari

To change the database engine for an existing table, you can use the ALTER TABLE statement: ALTER TABLE table_name ENGINE = new_engine_name. For example, if you want to switch from InnoDB to MyISAM, the command would be: ALTER TABLE table_name ENGINE = MyISAM.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1084


How to Change a users password from unix shell.

1223


Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1105