Chapter 0: MySQl preschool knowledge reserve

I. Database basics:

1. database: a container that stores organized data (usually a file or a group of files ).

2. Database Management System (DBMS): a software system for creating and manipulating databases.

3. table: a structured list of a specific type of data.

4. schema: displays the layout and features of databases and tables.

5. column: a field in the table. All tables are composed of one or more columns.

6. Data Type: The allowed data type. Each table column has a corresponding data type, which limits (or permits) the data stored in this column.

7. row: a record in the table.

8. primary key: The value uniquely identifies a column (or a group of columns) in each row in the table ).

Ii. Understanding SQL:

SQL (pronunciation sequel) is the abbreviation of the Structured Query Language (Structured Query Language). It is a Language specifically used to communicate with databases. SQL is a language.

Iii. Understanding MySQL:

MySQL is a DBMS, that is, a database management software. Specifically, it is a client-server-based database management software.

4. Understand MySQL tools:

As mentioned above, MySQL is a client-server-based DBMS. Therefore, to use MySQl, you need a client software to provide MySQL with commands to be executed. That is, you need a tool to write and test MySQL scripts.

1. MySQL command line utility

After installing MySQl, you can use this tool. The logon method is as follows:

[1] Ctrl + R run cmd to start the MS-DOC console;

[2] mysql-u user name [-h host name or IP address]-p Password

2. Navicat for MySQL

Navicat for MySQL is a powerful MySQL database management and development tool. It provides professional developers with a powerful enough cutting-edge tool and is easy to learn for new users. It supports most functions of the latest MySQL version, including triggers, stored procedures, functions, events, searches, and permission management.

Its official website: http://www.navicat.com

3. HeidiSQL

HeidiSQL is a graphical interface used to simplify your MySQL server and database management. This software allows you to browse your database, manage tables, browse and edit records, and manage user permissions. In addition, you can import data from text files, run SQL queries, synchronize tables between two databases, and export the selected tables to other databases or SQL scripts. HeidiSQL provides an easy-to-use interface for switching between database browsing, SQL queries, and labels with highlighted syntax. Other functions include BLOB and MEMO editing, large SQL script support, and user process management.

Its official website: http://www.heidisql.com

4. MySQL Workbench

Developed by MySQL, this tool is a cross-platform Visual Database Design Tool. It is a much-anticipated replacement for the DBDesigner4 project. It is a local graphical tool that supports multiple versions of Windows, Linux, and OS X.

Its official website: http://www.mysql.com/products/workbench/

5. phpMyAdmin

PhpMyAdmin is a free software tool written in PHP to manage MySQL databases over the network. It supports a large number of MySQL database operations. Its user interface supports most common operations, such as database management, tables, fields, associations, indexes, users, and permission management, you can also directly execute SQL statements.

Its official website: http://www.phpmyadmin.net/home_page/index.php

6. SQLyog

SQLyog is an all-around MySQL database management tool. The Community edition is free and open-source software and complies with the GPL license agreement. Most of the functions required by developers when using MySQL can be done by simply clicking the mouse. You can view the query result set and query profiler through the tag interface) server messages, table data, table information, and query history. In addition, developers can easily create views and stored procedures.

Its official website: https://www.webyog.com

The above describes several commonly used MySQL tools. Of course, there are many tools to choose from. But this is not the focus of this tutorial. In the following tutorial, we will use Navicat for MySQL. However, if you select other tools, you can read this series of tutorials.