All database connections are available in the Connections section. To create a new connection, click the Connections button on the main toolbar, and then click Create new connection. A new modal form opens. Select MariaDB and enter the connection details.
Your new MariaDB connection will appear in the list of all database connections.… Read the rest
To add a new index to a database table, edit your table, navigate to tab Indexes and click + Add Index.
Then it is necessary to add columns to the index. Click +Add Column to Index to display a dropdown with a list of available column names. Pick a column and then specify other index properties.… Read the rest
A short summary: Primary keys serve as the identifier of a unique record, it can be unique information, such as a driver’s license number, telephone number including area code, car VIN number, etc.… Read the rest