MySQL Operations summary

Source: Internet
Author: User

This semester studied the principle of database system, did the experiment, mark a remember.

Directory (without a key directory not happy ...) )

1. T-SQL simple query, connection query

(1) Using SQL statements to build a library, build a table, and insert records.

(2) Modify the table structure, including modifying the data type of the attribute column, adding a new attribute column, and deleting the existing attribute column.

(3) Insert using a single tuple and a multivariate group.

(4) Simple query operation, including projection, selection, data sorting, fuzzy matching query and so on. If the results are incorrect, modify them until they are correct.

(5) Connection query operation, including equivalent connection, natural connection, general connection, self-connection, outer connection.

2. Sub-query and combination

(1) In the DBMS Interactive environment, the SQL statement is used to build the database, build the table and insert the records.

(2) Nested query operations using the in, comparer, and exists operators.

(3) Group query, including the grouping conditional expression, the choice group condition expression method.

(4) Collection query.

(5) Use view to create statement view, query data through view

(6) Modification and deletion of the tape query

(7) Modifying and deleting data through views

3. Data control, data import/export, data backup and recovery

(1) Use SQL to control data security, including authorization and entitlement recovery.

(2) View the results after authorization and entitlement recovery

(3) The SQL Sever tool exports the data in a table to a file in a different format.

(4) Import file data from other formats into the database.

(5) Use SQL Sever to create a backup of a database (mass backup, incremental backup).

(6) Use the SQL Sever tool and the database backup you created to restore the database.

Simple query for T-SQL, connection query (1) Use SQL statements to build libraries, build tables, and insert records.

Build Library:

Build table:

Insert Record:

View

(2) Modify the table structure, including modifying the data type of the attribute column, adding a new attribute column, and deleting the existing attribute column.

Modifying the data type of a property column

Add a new Property column

Delete an existing attribute column

(3) Insert with single or multiple tuples

Unit group

Multivariate Group

(4) Simple query operation, including projection, selection, data sorting, fuzzy matching query and so on. If the results are incorrect, modify them until they are correct.

Projection

Choose

Sorting data

Fuzzy matching Query

(5) Connection query operation, including equivalent connection, natural connection, general connection, self-connection, outer connection.

preprocessing operations, establishing related tables

Equivalent connection

Natural connection

General Connection

Self-connect (create a property that can connect to itself first)

External connection

Subqueries and combinations (1) in a DBMS's interactive environment, SQL statements are used to build a library, build tables, and insert records. (2) Nested query operations using the in, comparer, and exists operators.

Using the In

Using the diff character

Using exists

(3) Group query, including the grouping conditional expression, the choice group condition expression method.

General grouping

Show all meeting Criteria tuples

Other condition groupings

(4) Collection query.

Union and Operation

Using Union for intersection operation

Differential operation with Union (F1-F2) and (F2-F1)

(5) Use view to create statement view, query data through view

(6) Modification and deletion of the tape query

(7) Modifying and deleting data through views

Data control, data import/export, database Backup and Recovery (1) Use SQL to control data security, including authorization and entitlement recovery.

Create a new user

New User Authorization

Reclaim New User Rights

(2) View the results after authorization and entitlement recovery

After authorization

After recycling rights

(3) Export the file (TXT) to another format.

Export student table to TXT in a certain format

View the exported TXT file in the relevant location

(4) Import file data from other formats into the database.

Rebuild the new table Temptxt, import the TXT file into the table and view

(5) Create a backup of a database (mass backup, incremental backup).

Use MySQL for massive backups

View backup files (including SQL statement Records)

(6) Restore Backup to Database

Delete a base table that has been backed up

Restore a base table using a backed up file

View post-recovery surface

Incremental backup: Modify the My-default.ini (without My.ini and my.conf files), add the Log-bin path and not get the relevant files after the operation on the Internet, using another method and unsuccessful. Query to know that MYSQL5 does not support incremental backup, refers to all 5 series? I use the MySQL5.6 ...

MySQL Operations summary

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.