Right-click the "Database" button, and then click "New Database". Choose a database name. Click the OK button (English: OK). The MySQL software Mai sequel is the most popular database management system open source, has many advantages, it is also easy to use and install the software MySQL sequel to the Windows operating system, the installer used may be a sequel to Windows (in English: MySQL The installer is for Windows) as follows.

Follow the installation steps until the installation is complete. After the installation process is complete, you must set a password (English: Root) for the root user. Its operation is as follows: From the program list (English: "All programs"), open the command interface of the program, under the "MySQL" folder Open the program named "MySQL 5.7 Command Line Client". Execute the following command: mysql -u root -p Enter the new password, and then press Enter on the keyboard (English: Enter). After that, Sequel language commands can be executed through the My Sequel command interface interface, which can be opened by following the first step in the previous steps.

To create a new database, enter the following command (replace "database name" with the desired database name): CREATE DATABASE database name. SQL (SQL: SQL) can be used to perform various operations on databases that support the language, such as creating tables and retrieving data based on specific conditions, especially adding and updating new data.

Database classes can be divided into several categories according to the structure of the database and how to deal with them, including: relational databases: data is stored in this type of database in the form of a table so that the data can be managed and accessed in many ways Structured query language is the main language from which to organize data in the database.

related articles：

How to visualize the computer screen

How to update the graphics card

Learn to do computer maintenance

How to create a database

Database distributed on the network

Posted by: askedthefox at 01:33 AM | No Comments | Add Comment
Post contains 336 words, total size 12 kb.