How do you convert to a different table type?

Answer Posted / amith

ALTER TABLE customers TYPE = InnoDB

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If we use sum function in mysql, does it return sum of that row or for that column?

520


How can I see connections in mysql?

467


What is the usage of "i-am-a-dummy" flag in mysql?

660


What are procedures in mysql?

483


What are the different mysql database engines?

523






What is the maximum number of records in mysql table?

446


What is clob in mysql

474


What does mysqli stand for?

487


What is truncate in mysql?

419


What is logs in mysql?

478


Is mysql frontend or backend?

475


How to load data files into tables with 'mysqlimport'?

469


What are the two types of queries?

435


Can you tell the difference between $message and $$message?

513


What is the difference between having and where clause in mysql? Explain

528