MySQL is a relational database management system developed by MySQL AB and currently owned by Oracle. MySQL is a relational database management system. Relational databases keep data in different tables instead of putting all data in one large warehouse, which increases speed and flexibility. MySQL’s SQL language is the most commonly used standardized language for accessing databases. MySQL software adopts the double licensing policy (this entry “licensing policy”), which is divided into community edition and commercial edition. Because of its small size, fast speed, low total cost of ownership, especially the characteristics of open source, the development of small and medium-sized websites choose MySQL as the website database. Because of the excellent performance of the community version, pairing PHP with Apache makes for a good development environment.
At the same time, companies also use MySQL application ability as one of the screening criteria in the interview, so: more and more programmers and would-be programmers, are beginning to seriously learn this technology.
Learning to program, you may hesitate to choose C++ or Java; For starters in data science, you may be torn between Python and R; No matter what, MySQL is an indispensable skill for IT professionals!
Let’s see the role of MySql database management system through practical operation.
Data connection page has search, refresh, new connection, data connection database, in the new connection name data type, connection string information;
Operation steps:
① Refresh the current page;
② Enter the connection name or connection type on the current page to search;
On the data modeling page, open the new table name, and fill in the required table name, table description, and table primary key (select the application primary key name from the drop-down box). In the field setting, you can add, delete, move up, and move down fields, which is convenient and quick to use.
Operation steps:
(1) Green “plus” in field Settings indicates the new line.
② The red “minus” in field Settings indicates deleting the current line;
When selecting a data in the data modeling page, edit, delete, open the data and view the subdirectory functions;
Operation steps:
(1) The current data cannot be deleted directly if it is applied;
② Select the table name and click the operation triangle to display the information of subdirectories under this directory;
③ When you select a data operation to open the data button, you enter the current selection table data page;
Select the search condition (F_ID, F_Parentld, F_FulName, etc.) in the drop-down box of the data page of the current table and enter the keyword under the condition to search, but the current search data jumps to the page;
Operation steps:
(1) If you clear the current input keyword click search, data return to the current table of all data pages;
② When the current table data close button is operated, the current table data page will close itself and jump to the data modeling page;
On the data synchronization page, perform data synchronization. Tips: Data synchronization is performed from database A to database B. Ensure that the database table structures are consistent; otherwise, data synchronization fails.
JNPF rapid development platform in data connection, data modeling, data synchronization connection data types at the same time MySql, SqlServer, Qracle database, to meet a variety of database language applications.