MARIADB Database Management System Learning (ii) graphical interface management tools using the Heidisql database

Heidisql is a graphical interface for simplifying MySQL server and database management. The software agrees to browse your database, manage tables, browse and edit records, manage user permissions, and more. In addition, you can import data from a text file, execute SQL queries, synchronize tables between two databases, and export selected tables to other databases or SQL scripts. Heidisql provides a simple and easy-to-use interface for switching SQL queries between database views and labels with syntax highlighting. Other features include Blob and MEMO editing, large SQL script Support, user process management, and more. The software is open to resources.

After the MARIADB is successfully installed, it appears on the desktop with the following label:

Double-click the Execute HEIDISQL Database graphical interface management tool

Create a data connection session

New "Create Session in Root category

To connect to the mariadb you just installed, click on the session name unnamed change to localhost, enter the root user Password,port set to 3308, open

Save your changes and click "Yes"

Create a data table

Right-click on the appropriate database to create a new table

Enter the data table name, stare, the following fields, you need to first click "Join?" button to add? field, first Field "userid", data type set to bigint, click Default Value column, where you can set your own active number

Save data table, prompt for no primary key

Set the primary key, right-click on the UserID field row, create a new index PRIMARY, create the Index management tab

Click Save again to create the data table successfully.

MARIADB Database Management System Learning (ii) graphical interface management tools using the Heidisql database