Tag Archives: different type of database langugae in mysql

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 »