How to change the database engine in mysql?



How to change the database engine in mysql?..

Answer / 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

More MySQL Interview Questions

Write a command to list all databases in mysql?

1 Answers  


How do I copy a table in mysql?

1 Answers  


how to take mysql database structure backup

6 Answers  


How to see the database architecture in MySQL??

3 Answers  


what is collation? how many types of installations in sql server?

3 Answers  


How to convert character strings to dates?

1 Answers  


What is a select query?

1 Answers  


How would you enter characters as hex numbers?

1 Answers  


In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

0 Answers  


What are the advantages of a procedure?

1 Answers  


How do I insert an image into mysql workbench?

1 Answers  


How can we repair a MySQL table?

2 Answers   Infosys,


Categories