MySQL Database basics

belongs to the relational database

Advantages:

Simple, small size

Source Code free Download

Superior performance

Powerful features

relational database in the so-called relationship, table hierarchy, column hierarchy

1. There is a primary foreign key association between tables

2. Creation and maintenance of the table, data deletion and modification

Structured Query Language (SQL statement) is a tool for manipulating databases

Data

Ddl

Database

Creating a database_name Database

ALTER database_name Database modification

Drop database_name Database Drop

Table

Create table_name table creation

ALTER TABLE_NAME TABLE modification

Drop table_name Table Drop

Index

CREATE index

Drop Index Drop Indexes

Dml

Select from query data statement

Update set updated data statement

INSERT INTO INSERTS data statement

Delete from deletes a data statement

DCL

Rights Management

Grant grants permissions or roles to users

Revoke revoke permissions from user

Transaction control

Commit COMMIT Transaction

Rollback rolling back transactions

MySQL data type

Common functions:

http://blog.csdn.net/sugang_ximi/article/details/6664748

This article is from the "Qinguan" blog, make sure to keep this source http://11083953.blog.51cto.com/11073953/1752495

MySQL Database Basics