Geek asks and answers

Default MySQL Database and How to Make Existing Non-InnoDB Become InnoDB

I am in the early stages of the project, and so far I have used the default MySQL database.

By the way, does the database have a default name?

My question is how to modify existing tables like utf-8 and InnoDB without deleting the current ones or creating new tables. Is there an alter table to make utf-8 and InnoDB table?

Thanks Alex

+3
source share
2 answers

MyISAM- this is the default Storage Engine for MySQL (prior to version 5.5.5, after which the value InnoDBbecame the default). There is no concept of a standard database .

InnoDB, :

ALTER TABLE tbl_name ENGINE = InnoDB;

utf8, :

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8;
+5

InnoDB, :

InnoDB

MyISAM, mytable mydb. :

use mydb
CREATE TABLE mytable_innodb LIKE mytable;
ALTER TABLE mytable_innodb ENGINE=InnoDB;
INSERT INTO mytable_innodb SELECT * FROM mytable;
ALTER TABLE mytable RENAME mytable_myisam;
ALTER TABLE mytable_innodb RENAME mytable;

. - InnoDB MyISAM . , , InnoDB.

, InnoDB

InnoDB

Howto: mysql InnoDB?

InnoDB

InnoDB MyISAM

+2

More articles:


All Articles