Add new Column in Existing Table in MySQL | ALTER table Command in MySql | Adding Table Columns
Add new Column in Existing Table in MySQL . ALTER table Command in MySql . Adding Table Columns .
Hello guys, In this video I will show that How You can Add new Column in Existing Table in MySQL. The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
To add a column in a table, use the following syntax :-
ALTER TABLE table
ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];
►First, you specify the table name after the ALTER TABLE clause.
►Second, you put the new column and its definition after the ADD COLUMN clause. Note that
COLUMN keyword is optional so you can omit it.
►Third, MySQL allows you to add the new column as the first column of the table by specifying the FIRST keyword. It also allows you to add the new column after an existing column using the AFTER existing_column clause. If you don’t explicitly specify the position of the new column, MySQL will add it as the last column.
Chapters:-
00:00-Introduction
00:29-ALTER Query
00:55-Use of ALTER Query
01:07-Output for ALTER Query
stay tune and watch full video .
Don't forget to like ,subscribe to our youtube channel . press the bellicon🔔 so you never miss any update from v2v class .
►Save this playlist and complete Full Course of MySQL :-
• Video
►Click here to subscribe :-
/ @v2vedtechllp
Follow us On Social Media :-
►Website of v2v classes - https://v2vclass.com
►Facebook - / v2vclass
►Instagram - / v2vclass
#v2v #v2vclass #mysql #MySQltutorial