#Alter
Автор: Global Technical Facts
Загружено: 2020-07-03
Просмотров: 156
Описание:
#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;
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
