#computerhindinotes #mysql #mysqltutorials
In this video, we'll take a look at how to use alter table to add, remove and change columns in your table. We'll also show you an example of how to use the statement to create a custom index.
This video will help you understand the MySQL Alter Table Statement syntax and its purpose. Watch this video to learn how to modify your tables in MySQL! By the end of this video, you'll be able to use the alter table statement confidently in your own MySQL database.
In this video of MySQL Tutorials in Hindi, we will learn to use alter table command.
The ALTER TABLE statement is used to add, delete or modify columns in an existing table.
It is also used to add and remove various constraints on existing tables.
MySQL Tutorial Beginners In Hindi
• What is SQL, RDBMS, SQ...
Topics covered in this video
00:00 Introduction
01:32 Use of Alter Table Statement in MySQL
02:32 Syntax of Alter Table Statement in MySQL
04:12 Add Column using Alter Table Statement
05:15 Modify Column using Alter Table Statement
07:07 Drop Column using Alter Table Statement