11/1/2023 0 Comments Navicat 12 for mysql![]() ![]() ![]() Insert Method (only for MRG_MYISAM table) You must have SELECT, UPDATE, and DELETE privileges for the tables you map to a MERGE table. UNION is used when you want to access a collection of identical MyISAM tables as one. To specify where the MyISAM storage engine should put a table's index file. To specify where the MyISAM storage engine should put a table's data file. ![]() Setting it to DEFAULT tells the storage engine to pack only long CHAR, VARCHAR, BINARY, or VARBINARY columns.Ĭheck this option if you want to delay key updates for the table until the table is closed. Setting the option to 0 disables all packing of keys. ![]() This usually makes updates slower and reads faster. Set this option to 1 if you want to have smaller indexes. Pack Keys (take effect only with MyISAM table) A value of 0 indicates that the default value should be used. The engine is allowed to change the value if necessary. This option provides a hint to the storage engine about the size in bytes to use for index key blocks. The minimum number of rows you plan to store in the table. This is not a hard limit, but rather a hint to the storage engine that the table must be able to store at least this many rows. The maximum number of rows you plan to store in the table. You need to set this only for large tables with variable-size rows. Note: Aria table is supported from MariaDB 5.1 or later.Ĭheck this option if you want index and data use page checksums for extra safety.Ĭheck this option if you want crash-safe.Īn approximation of the average row length for your table. The auto increment value indicates the value for next record.Ĭhecksum/ Table Checksum (only for MyISAM and Aria tables)Ĭheck this option if you want MySQL to maintain a live checksum for all rows. Set/Reset the Auto Increment value in the edit field. Define the type of the character set for table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |