Two MySQL preliminary, data types and SQL statements

Source: Internet
Author: User
Tags mysql client

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.