Two MySQL preliminary, data types and SQL statements

Features of the DBMS:

Data management independence;

Effectively complete data access

Data integrity and security

Centralized data management

Concurrent storage and failure recovery

Reduce application development Cycles

Mysql:

-h 127.0.0.1 localhost client and server on the same machine, connection mode:

Linux:socket socket File native

Windows:memory Shared Memory

MySQL client:

Interactive mode

Batch mode executes MySQL script

Command categories in interactive mode:

Client commands

The server-side command must use the statement terminator, which defaults to a semicolon ";"

MySQL default of three databases:

Information_schema saves the data generated during MySQL operation in an in-memory database. (Guaranteed compatibility)

Mysql

Test is used

Relational database objects:

Library

table

Index

View

Constraints

Stored Procedures

Storage functions

Trigger

Cursor

User

Permissions

Things

Table:

Row: Row

Column: Field,column

Table: Entities

Field Name: Data type, type modifier (limit)

Character char (n) VARCHAR (n) default case insensitive

BINARY (n) VARBINARY (n) Case-sensitive

TEXT (N)

BLOB (N)

Numerical

Date

Boolean

Two MySQL preliminary, data types and SQL statements