MySQl preschool knowledge reserves _ MySQL

MySQl pre-school knowledge reserve bitsCN.com

MySQl pre-school 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.

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

BitsCN.com