myisamchk: error: myisam_sort_buffer_size is too small
Got the following error while trying to repair a table individually: [crayon-5ab48e0c5c3f1382010449/] The command I…
It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key, connect to the db server, login or open up your favorite MySQL client.
Without selecting any table, issue the following command:
Where <TABLE> is the name of the table you want to check.
The result returned should have a line show up with the Primary Key.
Note: If the result is empty, that means the table does not have a Primary Key.