DCL: Data Control language, mainly create users, manage user rights
Main keywords:
Great Grant Revoke drop
1. Create user
CREATE user username @ip address identified by password
CREATE user username @ '% ' identified by password
2. Give user authorization
GRANT permission 1,..., permission n on database. Table name to user name @ip address
3. Revoke permission
REVOKE permission on database name. Table name from user name @ip address
Note: A
Data Control Language (DCL)
permissions in MySQLIn MySQL, permissions are some of the system's default "nouns" (words), about 30, each of which indicates "what work can be done." Assigning permissions is equivalent to what a user can do. The main permissions are as follows:
user information from MySQL in MySQL is stored in the user table of the system database MySQL: (You can also query its corresponding permissions)
Use MySQL;
SELECT Host,user,pass
are often not introduced. The language requires a commit. There are also commonly used LOCK TABLE.
There are other unfamiliar:
CALL– Invoke a Pl/sql or Java subroutine
EXPLAIN PLAN -Parsing the data access path
3. Dcl–data Control Language
Database Control Language: Authorization, role control, etc.
GRANT– Give the user access rights
REVOKE– Recall Authorization Permissions
4. Tcl–transaction Control Language
Transaction Control Language
CO
= outer_table. EMPNO);Find departments with no employees in the Dept tableSelect Deptno,dname from DEPT where is not EXISTS (select ' X ' from EMP where EMP. Deptno=dept. DEPTNO);In HR user authorization Scott can query the permissions of the Employees,departments tableGRANT SELECT on departments to SCOTT;GRANT SELECT on EMPLOYEES to SCOTT;The Scott user creates a employees,departments table with the same name and copies the dataCREATE TABLE EMPLOYEES as SELECT * from HR. EMPLOYEES;CREATE TABLE
- Data Definition language objects used to define a database, such as tables, views, indexes, etc.DDL does not require a commit.CREATEAlterDROPTRUNCATECOMMENTRENAMEDML - Data Manipulation Language Update, add and delete records in database tables such as UPDATE, INSERT, deleteProvided by the DBMS for use by a user or programmer to implement operations on data in a database.DML is divided into two classes: interactive DML and embedded DML.Depending on the level of the language, DML can be divide
Label:DML: Data manipulation language, mainly the completion of new data, modify, delete and query operations.DDL: A data definition language that is used primarily to create or modify tables, views, stored procedures, users, and so on.DCL: A Data Control language that is used to set or change the permissions of a database user or role, including (Grant,deny,revoke, etc.) statements. By default, only people such as Sysadmin,dbcreator,db_owner or db_securityadmin have the power to execute the DCL
drop user user_name[,user_name2,...]; --View users Select User,host from Mysql.user; --View online users SELECT Substring_index (host, ': ', 1) as Host_short, NBSP ; Group_concat (DISTINCT user) as users, COUNT (*) as Threads N Bsp from Information_schema.processlist GROUP by Host_short NB Sp ORDER by COUNT (*), host_short; --Create a databaseCreate DATABASE db_name [default character set UTF8 collate utf8_general_ci]; Example : Create DATABASE School d
This article focuses on the differences and understandings of DDL, DML, and DCL, and the need for friends to refer to the followingDML, DDL, DCL differences.General Explanation:DML (Data Manipulation language):They are select, UPDATE, INSERT, DELETE, just like its name, these 4 commands are the languages used to manipulate the data in the databaseDDL (data definition Language):DDL is more than DML, the main
Transferred from: http://www.iteye.com/topic/875420 If you search the reason why the DCL in Java fails in the online analysis, will talk about the compiler will do optimization and so on, I believe you see this must feel very frustrated, very helpless, the process of their own writing is not confident. I understand this feeling because I've been there, and that's probably why people on the Internet have always liked to talk about
The SQL language has two components:
DML (data manipulation language): They are SELECT, UPDATE, INSERT, and DELETE, just like their names. These four commands are used to operate the data in the database.
DDL (data definition language): DDL is more than DML. The main Commands include CREATE, ALTER, and DROP. DDL is mainly used to define or change the TABLE structure, data Types, links and constraints between tables, etc. They are mostly used when creating tables. Respondent: zhongsojun | level 3
For SQL languages, there are two components:
DML (Data Manipulation language): They are select, UPDATE, INSERT, DELETE, just like its name, these 4 commands are the languages used to manipulate the data in the database.
DDL (data Definition Language): DDL is more than DML, the main commands are create, ALTER, drop, etc., the DDL is mainly used in the definition or change of tables (table) structure, data type, table links and constraints, such as the initialization of work, Most of them are used
fields, as well as the role of the index will know. Such operations as primary KEY constraints, unique constraints, non-null constraints, FOREIGN KEY constraints, verification constraints, and default constraints are all attributes of the table, so here I think they are all properties of the table. ) RELATED Links: Understanding of DDL, DML, and DCL (1-1, DDL: Data definition) 2, dml 2-1, DML overview nbsp DML (Data manipulation Language-con
Database DML, DDL, DCL difference., dmldcl
Overall explanation:DML (data manipulation language ):They are SELECT, UPDATE, INSERT, and DELETE, just like their names. These four commands are used to operate the data in the database.DDL (data definition language ):DDL is more than DML. The main Commands include CREATE, ALTER, and DROP. DDL is mainly used to define or change the TABLE structure and data type, most of them useDCL (Data Control Language ):I
Dml
English abbreviation
DML = Data manipulation Language, a command that enables users to query a database and manipulate the computer language of data in an existing database. Specifically, update update, insert INSERT, delete deletion.
DML = Data Media Laboratory, lab.
DML = Doctor of Modern Languages, PhD in modern languages.
DML (datamanipulation Language) Data manipulation language, one of the SQL classifications, in addition to the DDL (datadefinition Language) data definition language an
DML, DDL, DCL differences.
General Explanation:
DML (Data Manipulation language):
They are select, UPDATE, INSERT, DELETE, just like its name, and these 4 commands are the languages used to manipulate the data in the database.
DDL (data definition Language):
DDL is more than DML, the main commands are create, ALTER, drop, etc., the DDL is mainly used to define or change the structure of tables (table), data type, table links and constraints, such as
In Singleton mode, the most important concern is the number of object creation times and the time when the object was created.
The Singleton mode can be very simple, and only one class is needed to complete it (look at the poor UML diagram in this chapter ). HoweverThe Singleton mode can be quite complex than the first five modes, for example, involving the DCl double checked detection (double checkedLocking), involving multiple classloaders, cross-JV
small test to see what you understand to several:Char**argv Argv:pointer toCharArrayint(*daytab) [ -] Daytab:pointer to array[ -] ofintint*daytab[ -] daytab:array[ -] of Pointer tointvoid*Comp () comp:function returning pointer tovoidvoid(*comp) () Comp:pointer to function returningvoidChar(*(*x ()) []) () x:function returning pointer to array[] of pointer to function returningCharChar(* (*x[3])())[5] x:array[3] of pointer to function returning pointer to array[5] ofChar-------------------------
table, drop can delete the table, from here we can see the height of the DDL station, he will not operate on the specific data.Data Control Language DCL:The operation of the DCL (Data Control Language) is the permission of the database object, the determination of which makes the data more secure, the user has the right to operate on a certain kind of data is determined by the DBA, the DCL operator (user)
1.DDL (data definition Language ) DB Definition Language statements is used to define the database structure O R schema.DDL is one of the four functions of SQL language.A three-level structure for defining a database, including external, conceptual, internal, and inter-image, defining constraints such as data integrity, security controls, and moreDDL does not require a commit.CREATEAlterDROPTRUNCATECOMMENTRENAME2.DML (datamanipulation Language) Manipulation Language statements is used for managi
Most database companies work to address this problem in two ways:(1) Expand SQL, introduce the procedural structure in SQL, (2) Embed SQL into the high-level language,In order to complete a complete application together.Two. Classification of SQL languagesThe SQL language is divided into four categories: Data Query Language DQL, Data manipulation language DML, data definition language DDL, Data Control Language DCL.1. Data Query Language DQLThe DQL ba
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.