DDL Commands in MYSQL Create, Alter, Rename, Truncate and Drop
Автор: Digital Sukrut
Загружено: 2025-08-12
Просмотров: 90
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![Practical demonstration of installing MySQL and MySQL Workbench on Windows |Set the path MYSQL[2025]](https://imager.clipsaver.ru/Y9vg5h-82Yk/max.jpg)
