Tag Archives: interview question in mysql/php

Explain DDL,DML,DCL in mysql with Examples

DDL (Data Definition language) statements are used to define the database structure or schema following are the examples. 1.CREATE- To create objects in the database. 2.ALTER- alter the structure of the database. 3.DROP- delete objects from the database 4.TRUNCATE-remove all records from the table,including all the spaces allocated for the records are removed. 5.COMMENT-add comments… Read More »