2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→Maintenance: Added "Shrink MyISAM Table"
(→INSERT / UPDATE Rows: Updated sub-headings and added INSERT ... SELECT ... ON DUPLICATE) |
(→Maintenance: Added "Shrink MyISAM Table") |
||
| Line 267: | Line 267: | ||
CHECK TABLE table; # Checks for table corruption | CHECK TABLE table; # Checks for table corruption | ||
REPAIR TABLE table; # Repairs a corrupted table | REPAIR TABLE table; # Repairs a corrupted table | ||
</source> | |||
=== Shrink MyISAM Table === | |||
<source lang="mysql"> | |||
OPTIMIZE TABLE SystemEvents; | |||
</source> | </source> | ||