Te SQL DELETE
ka whakamahia te tauākī hei muku i ngā rekoata mai i te teepu, ko te DROP
whakamahia te tauākī ki te muku i te teepu he pātengi raraunga ranei.
Ko te TRUNCATE TABLE
ka taea hoki te korero ki te whakakore i nga rekoata mai i te teepu.
Ko te DELETE
tauākī i te SQL whakamahia ki te muku pūkete i te teepu pātengi raraunga. Ka taea e taatau te tango i nga rekoata katoa mai i te teepu, ki te muku ranei i nga rekoata motuhake ma te whakamahi i te whiti WHERE.
DELETE FROM table_name WHERE condition;
Me kii taatau he teepu e kiia ana ko 'Nga Kaimahi' me nga rekoata e whai ake nei:
+------------+-----------+----------+------------+ | EmployeeID | FirstName | LastName | Department | +------------+-----------+----------+------------+ | 1
| Mark
| Otto
| Finance | | 2
| Jacob
| Thornton | IT
| | 3
| Su
| Bird
| Marketing | | 4
| Sam
| Burger | IT
| +------------+-----------+----------+------------+
Ko te tohu e whai ake nei ka tangohia a “Jacob Thornton” mai i te teepu “Kaimahi”:
DELETE FROM Employees WHERE FirstName = 'Jacob' AND LastName = 'Thornton';
Panui:I te tauira i runga ake nei, e rua nga tikanga e whakamahia ana e matou, WHERE me AND , ara ma te ingoa tuatahi me ingoa whakamutunga Hei whakarite tenei me whakakore e tatou nga rekoata tika, mena kaare he kaimahi ano he ingoa kotahi ano tona.Ko te tohu e whai ake nei ka muku i nga rekoata katoa mai i te teepu “Kaimahi”:
DELETE * FROM Employees;
Panui:Ko te Mukua Ma te tauākī e tango nga rekoata mai i te teepu, engari kaore e muku i te teepu ano.Ko te TRUNCATE TABLE
ka taea hoki te whakamahi i nga korero ki te muku i nga rekoata mai i te teepu, engari kaua ko te teepu.
Tauira:
TRUNCATE TABLE table_name;
Ko te DROP
tauākī i te SQL whakamahia ki te muku i te tepu he pātengi raraunga ranei.
Ko te waehere e whai ake nei ka taka i te teepu e kiia ana ko “Nga Kaimahi”:
DROP TABLE 'Employees';
Panui:Kia tupato ki te whakamahi i te MURIU tauākī Ka whakatakahia he teepu, ka mukua katoa nga rekoata kei roto i te teepu.Ko te waehere e whai ake nei ka makere i te papaapu raraunga e kiia ana ko 'KaimahiDB'.
DROP DATABASE 'EmployeesDB';
Panui:Kia tupato ki te whakamahi i te MURIU tauākī Ka maturuturu ana i te papaarangi, ka muku katoa nga teepu i roto i te papaarangi.