![]() to know the engine of a table − show table status from yourDatabaseName Like ‘yourTableName’. With MyISAM, a DML statement will obtain an exclusive lock on the table, and while that lock is held, no other session can perform a SELECT or a DML operation on the table. Here is the syntax that can be used for a specific table i.e. The below syntax can be used for multiple tables − show table status from yourDatabaseName Only the InnoDB and MyISAM storage engines support indexing on BLOB and TEXT columns. Let’s create tables with InnoDB storage Enginesįirst of all we create one table say Person which Engine is InnoDB.To know whether a MySQL table is using MyISAM or InnoDB engine then you can use below syntax. myisam engine is used by mysql system tables, so it can not be disabled simply.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |