How to alter & modify a column in MySQL|MySQL ALTER Tutorial in Hindi

Опубликовано: 04 Октябрь 2024
на канале: WebTechPool
76
7

alter command in MySql [in Hindi]

What is ALTER TABLE in MySQL
How to use ALTER TABLE in MySQL
ADD CONSTRAINT in ALTER TABLE
DROP CONSTRAINT in ALTER TABLE
MODIFY COLUMN data type in ALTER TABLE
ADD COLUMN with data type using ALTER TABLE in MySQL
DROP COLUMN using ALTER TABLE in MySQL


1 MySQL Introduction, Brief introduction of MYSQL    • MySQL Introduction, Brief introductio...  
1 Download and Install MySQL on Windows,Download MySQL Workbench 8.0.3    • Download and Install MySQL on Windows...  
2 Create table in MySQL (in Hindi), How to Create a Table in MySQL?    • Create table in MySQL (in Hindi), How...  
3 Select command in MySQL | How to see table data in MySQL workbench 8.0    • Select command in MySQL | How to see ...  
4 Rename Column Name | How to Use SELECT Command to Rename a Column    • Rename Column Name | How to Use SELEC...  
5 "MySQL Add Data Into Tables | How to insert data in a table with MySQL
"    • MySQL Add Data Into Tables | How to i...  
6 MySQL Constraints Tutorial NOT NULL, DEFAULT, UNIQUE, CHECK, PRIMARYKEY, INDEXES, FOREIGNKEY    • MySQL Constraints Tutorial NOT NULL, ...  

Learn what ALTER TABLE is in MySQL and how it can be used to modify database tables, including columns.
Discover the syntax and usage of ALTER TABLE in MySQL and how to use it to modify tables and columns.

Learn how to use ADD CONSTRAINT in ALTER TABLE to add a new constraint to a MySQL table column.
Learn how to use DROP CONSTRAINT in ALTER TABLE to remove a constraint from a MySQL table column.

Discover how to use MODIFY COLUMN in ALTER TABLE to change the data type of a MySQL table column.

Learn how to use ADD COLUMN in ALTER TABLE to add a new column with a specific data type to a MySQL table.

Learn how to use DROP COLUMN in ALTER TABLE to remove a column from a MySQL table.