Several basic concepts of MySQL Database

1. Table

A database table is a collection of two-dimensional arrays used to store the logical structure of data and manipulation data. A row is a record, a column is a field, and each column represents a property of a record, with the corresponding description.

2. Data type: The data type determines the format of the data stored in the computer and represents the different information types. Common data types are: Integer data type, floating point data type, exact decimal type, binary data type, datetime data type, string data type.

3. Primary key

Primary key: Primary key is also called the main code, which uniquely identifies each record in the table. You can define one or more columns in a table as a primary health. There cannot be no more than two columns of the same value on the primary health column, nor can it be a null value.

4. SQL language

The SQL language consists of the following 4 sections

A, data definition language, Ddl:create,alter,drop.

b, data manipulation language: Dml:insert,update,delete.

C, data Query Language: Dql:select

D, Data Control Language: Dcl:grant,revoke,commit,rollback.

5. Database Access Technology

1. ODBC

2. JDBC

3. ADO

4. PDO

6. Common MySQL Tools

1, MySQL Workbench 2, Phpadmin 3, Navicat 4, Mysqldumper 5, SQLyog

Several basic concepts of MySQL Database