Скачать или смотреть #Alter

#dbms #alter #delete #update #drop #modify #rename #onlinetutorials #covid19 #alterdeleteupdatedroponlinetutorials #freetutorials #companydatabase #howtoimplementalterdeleteupdate #dbms #mysql #mysqltutorials #dbmstutorials

DESCRIPTION:
.Alter- syntax
The basic syntax used to add a column to an already existing table is shown below
ALTER TABLE `table_name` ADD COLUMN `column_name` `data_type`;
2.The DROP command is used to
Delete a database from MySQL server
Delete an object (like Table , Column)from a database.
The syntax to DROP a table from Database is as follow -
DROP TABLE `sample_table`;
3.The UPDATE command is used to change the name of an existing database object(like Table,Column) to a new name.
Renaming a table does not make it to lose any data is contained within it.
Syntax:-
The rename command has the following basic syntax.
RENAME TABLE `current_table_name` TO `new_table_name`;
4.Delete keyword is used to delete column and table. To delete the particular row we need to mention particular condition same as update statement.
Delete Column Sql Syntax:
DELETE FROM Table_Name WHERE condition;