建站
咨詢
售后
建站咨詢
新聞中心
SQL Delete命令用于刪除SQL數(shù)據(jù)庫(kù)中的記錄，下面就為您詳細(xì)介紹SQL Delete命令的用法，希望可以讓您對(duì)SQL Delete命令有更深的認(rèn)識(shí)。
成都創(chuàng)新互聯(lián)公司主要從事成都網(wǎng)站設(shè)計(jì)、做網(wǎng)站、網(wǎng)頁(yè)設(shè)計(jì)、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務(wù)。立足成都服務(wù)上高,十載網(wǎng)站建設(shè)經(jīng)驗(yàn),價(jià)格優(yōu)惠、服務(wù)專業(yè),歡迎來(lái)電咨詢建站服務(wù):18982081108
DELETE 聲明
The DELETE statement is used to delete rows in a table.
DELETE 聲明常用來(lái)刪除表中的數(shù)據(jù)。
語(yǔ)法
DELETE FROM table_nameWHERE column_name = some_value
--------------------------------------------------------------------------------
Person:
LastName FirstName Address City
Nilsen Fred Kirkegt 56 Stavanger
Rasmussen Nina Stien 12 Stavanger
--------------------------------------------------------------------------------
Delete a Row
刪除一條記錄
"Nina Rasmussen" is going to be deleted:
"Nina Rasmussen" 的所有個(gè)人信息將被刪除：
DELETE FROM Person WHERE LastName = 'Rasmussen'
結(jié)果
LastName FirstName Address City
Nilsen Fred Kirkegt 56 Stavanger
--------------------------------------------------------------------------------
Delete All Rows
刪除所有記錄
It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:
可以不刪除數(shù)據(jù)表且刪除里面的所有記錄行。這就意味著數(shù)據(jù)表構(gòu)架，屬性以及索引都會(huì)完整保留：
DELETE FROM table_name或DELETE * FROM table_name
網(wǎng)頁(yè)名稱：使用SQLDelete命令刪除記錄
網(wǎng)站地址：http://www.5511xx.com/article/djdihip.html
