Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is CRUD DDL or DML operation?

Tags:

sql

crud

Is CRUD classified as DDL or DML or both. CRUD being the operation Create Read Update and Delete

like image 988
Steffan Harris Avatar asked Jan 29 '12 23:01

Steffan Harris


1 Answers

CRUD operations when applied to an SQL database map directly to DML statements. You have to bear in mind that the "C" in CRUD corresponds to the INSERT statement in SQL which creates an instance of something in a table. There is a CREATE statement in SQL that used for DDL operations but this is not the same sense of "Create" as in CRUD.

 Create = INSERT
 Read   = SELECT
 Update = UPDATE
 Delete = DELETE
like image 163
Larry Lustig Avatar answered Oct 12 '22 11:10

Larry Lustig