MySQL II: Database operations

Read Catalogue

• A knowledge reserve
• Two initial knowledge of SQL language
• Three-system database
• Four Create a database
• Five Database related operations

A knowledge reserve

MySQL database basic Operation knowledge Reserve

Database server: One computer (high memory requirements)

Database management system: Like MySQL, is a software

Database: Oldboy_stu, equivalent to Folder

Table: Student,scholl,class_list, equivalent to a specific file

Record: 1 Zeng 123456789, equivalent to one line of content in a file

Two initial knowledge of SQL language

SQL (structured query Language, structured queries language)
The SQL language is primarily used to access data, query data, update data, and manage relational database systems, which are developed by IBM. There are 3 types of SQL languages:
DDL statement Database Definition Language: Database, table, view, index, stored procedure, such as Create DROP ALTER
DML statement Database manipulation language: Inserting data insert, deleting data Delete, updating data update, querying data Select
DCL Statement Database Control Language: for example, to control user access rights grant, REVOKE

Three-system database

INFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permission information, character information, etc.
Performance_schema:mysql 5.5 started a new database: Mainly used to collect database server performance parameters, record the processing of query requests occurred in various events, locks and other phenomena
MySQL: Authorization library, access information for primary storage system users
Test:mysql Database System Auto-created test database

Four Create a database

1 syntax (help CREATE DATABASE)

CREATE database name CharSet UTF8;

2 Database naming rules:

can be by letter, number, underscore, @, #, $ case-sensitive uniqueness cannot use keywords such as create select cannot use the number maximum 128 bits alone

Five Database related operations

1 View the database show databases;show CREATE DATABASE Db1;select database (); 2 Select the databases use database name 3 Delete database Dorp database name; 4 Modify database Alter DAT Abase DB1 CharSet UTF8;

MySQL II: Database operations