Search
 
SCRIPT & CODE EXAMPLE
 

SQL

tipos da linguagem SQL

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 :: SQL Modulo (Remainder) Operator 
Sql :: ring execute query then print the query result. 
Sql :: ORACLE: How to get all column with GROUP by only 1 column? 
Sql :: t-sql cheat sheet 
Sql :: how to set up an anonymous function to variable in swift 
Sql :: SQL MAX() and MIN() with Strings 
Sql :: allow all local clients (local socket connections) to connect to the kodekloud_db1 
Sql :: sql tablo hangi sp de 
Sql :: sintaxis SELECT sql 
Sql :: sort by 
Sql :: postgres multiple left join causing duplicates jsonb_agg 
Sql :: influxdb clone measurement 
Sql :: exel bulk insert 
Sql :: basic structure of sql expression having clause 
Sql :: oracle sqlp update amount / quantity 
Sql :: What are the advantages of MySQL when compared with Oracle? 
Sql :: Original Query 
Sql :: get all jobs if salary more than 5500 less than 10000 sql 
Sql :: Having trouble running COUNT in my INSERT INTO statement 
Sql :: price-colour 
Sql :: SQL Hello, [firstname] [lastname] 
Sql :: insert data mysql with cmd 
Sql :: why we have to set the password for my sql server 
Sql :: run all sql file from folder postgres command line 
Sql :: turnicate in mysql 
Sql :: creating a joined view in mysql 
Sql :: transaction in java mysql 
Sql :: fetcht he leftmost word in a comma separated string in sql 
Sql :: ring MySQL presents the usage of MySQL_Autocommit(), MySQL_Commit() & MySQL_RollBack() functions. 
Sql :: c# execute transact sql 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =