What are the four categories of database languages?
Database languages are divided into four categories: 1. Data query language DQL; 2. Data manipulation language DML; 3. Data definition language DDL; 4. Data control language DCL.
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
SQL language is divided into four categories: data query language DQL, data manipulation language DML, data definition language DDL, and data control language DCL.
1. Data query language DQL
The basic structure of data query language DQL is a query block composed of SELECT clause, FROM clause, and WHERE
clause :
SELECT <field name table>
##FROM
2. Data manipulation language DMLData manipulation language DML mainly has three forms: 1) Insert: INSERT2) Update: UPDATE3) Delete: DELETE 3. Data Definition Language DDLData Definition Language DDL is used to create various objects in the database ----- tables, views, indexes, synonyms, clusters, etc. such as:WHERE
CREATE TABLE/VIEW/INDEX/SYN/CLUSTERTable view index synonym cluster
DDL operations are submitted implicitly! Cannot rollback4. Data control language DCLData control language DCL is used to grant or revoke certain privileges to access the database, and control the time and effect of database manipulation transactions, and perform operations on the database. Surveillance etc. Such as:1) GRANT: Authorization.
2) ROLLBACK [WORK] TO [SAVEPOINT]: Roll back to a certain point. Rollback---ROLLBACK The rollback command returns the database state to the last submitted state. The format is:SQL>ROLLBACK;
3) COMMIT [WORK]: Submit. There are three types of submitted dataIn the insertion, deletion and modification operations of the database, the transaction is completed only when it is submitted to the database. Before the transaction is committed, only the person operating the database has the right to see what has been done. Others can only see it after the final commit is completed. There are three types of submitted data: explicit submission, implicit submission and automatic submission. These three types are described below.(1) Explicit submission
The submission completed directly using the COMMIT command is an explicit submission. The format is:SQL>COMMIT;
(2) Implicit submissionThe submission completed indirectly using SQL commands is implicit. submission. These commands are:
ALTER, AUDIT, COMMENT, CONNECT, CREATE, DISCONNECT, DROP, EXIT, GRANT, NOAUDIT, QUIT, REVOKE, RENAME.(3) Automatic submission
(Recommended tutorial:若把AUTOCOMMIT设置为ON,则在插入、修改、删除语句执行后, 系统将自动进行提交,这就是自动提交。其格式为: SQL>SET AUTOCOMMIT ON;
Copy after loginmysql video tutorial)
The above is the detailed content of What are the four categories of database languages?. For more information, please follow other related articles on the PHP Chinese website!
Statement of this WebsiteThe content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cnHot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Assassin's Creed Shadows: Seashell Riddle Solution4 weeks ago By DDDWhat's New in Windows 11 KB5054979 & How to Fix Update Issues3 weeks ago By DDDWhere to find the Crane Control Keycard in Atomfall4 weeks ago By DDDRoblox: Dead Rails - How To Complete Every Challenge1 months ago By DDDHow to fix KB5055523 fails to install in Windows 11?2 weeks ago By DDDHot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics