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 |
Write a command to list all databases in mysql?
How do I copy a table in mysql?
how to take mysql database structure backup
How to see the database architecture in MySQL??
what is collation? how many types of installations in sql server?
How to convert character strings to dates?
What is a select query?
How would you enter characters as hex numbers?
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?
What are the advantages of a procedure?
How do I insert an image into mysql workbench?
How can we repair a MySQL table?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)