h1

DML si DDL

October 31, 2009

DML – acronim pt. Data Manipulation Language

Ce tine de DML:

Clauza SELECT – extrage date dintr-o BD

Clauza UPDATE – updateaza (modifica) inregistrari dintr-o BD

Clauza DELETE – sterge date dintr-o bd

Clauza INSERT INTO – insereaza inregistrari intr-o tabela

DDL – acronim pt. Data Definition Language

Ce tine de DDL:

CREATE DATABASE – creeaza BD

ALTER DATABASE – modifica structura unei BD

CREATE TABLE – creeaza o tabela

ALTER TABLE – modifica structura unei tabele

DROP TABLE – sterge o tabela cu numele specificat

DROP DATABASE – sterge o BD cu numele specificat

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: