DDL Commands in MYSQL Create, Alter, Rename, Truncate and Drop скачать в хорошем качестве

DDL Commands in MYSQL Create, Alter, Rename, Truncate and Drop

In MySQL, DDL stands for Data Definition Language. In this video, I started by explaining some basic concepts like what a database and a table are. Then, I explained all the DDL commands in detail with practical examples DDL commands affect the schema of the database, not the data inside it Create - Create database or its object CREATE TABLE table_name (column1 data_type, column2 data_type, ...); Alter - Alter the structure of the database ALTER TABLE table_name ADD COLUMN column_name data_type; Alter table can modify column Rename - Rename an object existing in the database RENAME TABLE old_table_name TO new_table_name; Truncate - Remove all records from a table, including all spaces allocated for the records are removed TRUNCATE TABLE table_name; Drop - Delete objects from the database DROP TABLE table_name; #ddl #mysql #mysqltutorials #database #dbms #dbmstutorials