Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mdl ddl acl

A linguagem SQL é dividida em subconjuntos de acordo com as operações que 
queremos efetuar sobre um banco de dados, tais como:

DML - Data Manipulation Language - Linguagem de Manipulação de Dados.
Exemplo: INSERT, DELETE e UPDATE

DDL - Data Definition Language - Linguagem de Definição de Dados
Exemplo: CREATE, ALTER e DROP

DCL - Data Control Language - Linguagem de Controle de Dados.
Exemplo: GRANT, REVOKE E DENY

DTL - Data Transaction Language - Linguagem de Transação de Dados.
Exemplo: BEGIN TRANSACTION, COMMIT E ROLLBACK

DQL - Data Query Language - Linguagem de Consulta de dados.
Exemplo: SELECT 
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle list user locked 
Sql :: SQL DATEDIFF(date_part, start_date, end_date) 
Sql :: round .5 to 1 in sql server 
Sql :: what is truncate in sql 
Sql :: hour must be between 1 and 12 
Sql :: how to limited number of rows in db2 select * from imglib FETCH FIRST 20 ROWS ONLY 
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause 
Sql :: sql server fn_dblog 
Sql :: sqlite löschen einer tabelle 
Sql :: memberikan password root mysql 
Sql :: create temp table sql 
Sql :: Write an SQL query to fetch the count of employees working in the department ‘Admin’. 
Sql :: set a value by excuting stored procedure 
Sql :: cascade syntax in sql 
Sql :: mysql varchar length 
Sql :: illuminate database queryexception could not find driver (sql select * from 
Sql :: longtext sql 
Sql :: Truncate a table then insert data 
Sql :: mysql calcular idade 
Sql :: create procedure 
Sql :: Oracle cx_Oracle example 
Sql :: oracle list partitions 
Sql :: sql order by 
Sql :: min max in sql 
Sql :: read sql file in python pandas 
Sql :: incorrect datetime value sql table error 1292 
Sql :: postgres enumerated type 
Sql :: mysql run file command 
Sql :: adding column 
Sql :: timestamp type in sql 
ADD CONTENT
Topic
Content
Source link
Name
1+4 =