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