Karibu kwenye Somo la 15 la MySQL Database Full Course kwa Kiswahili.

Katika somo lililopita tulijifunza kutumia:

UPDATE

na:

SET

kubadilisha data iliyopo kwenye table.

Sasa tutajifunza jinsi ya kufuta records kutoka kwenye MySQL database.

Command kuu tutakayotumia ni:

DELETE

Hili ni somo muhimu sana kwa sababu ukitumia DELETE vibaya unaweza kufuta data ambayo hukukusudia kuifuta.

Kwa hiyo tutajifunza siyo tu jinsi ya kutumia DELETE, bali pia jinsi ya kuitumia kwa usalama.

Malengo ya Somo

Baada ya kumaliza somo hili utaweza:

• Kuelewa DELETE ni nini
• Kutumia DELETE FROM
• Kufuta record moja
• Kufuta record kwa Primary Key
• Kutumia WHERE
• Kufuta records nyingi kwa condition
• Kutumia AND
• Kutumia OR
• Kuelewa hatari ya DELETE bila WHERE
• Kuangalia record kabla ya DELETE
• Kuelewa tofauti ya DELETE, DROP na TRUNCATE
• Kutumia DELETE kwa usalama katika mifumo halisi

1. DELETE ni Nini?

DELETE ni SQL command inayotumika kuondoa records zilizopo kwenye table.

Mfano:

DELETE FROM students
WHERE student_id = 3;

Hii ina maana:

Futa student mwenye ID 3.

2. Structure ya DELETE

Muundo wa kawaida ni:

DELETE FROM table_name
WHERE condition;

Mfano:

DELETE FROM students
WHERE student_id = 5;

3. Kwa Nini WHERE ni Muhimu?

WHERE inaamua ni records zipi zifutwe.

Mfano:

DELETE FROM students
WHERE student_id = 2;

Hii inalenga record moja.

Lakini:

DELETE FROM students;

inaweza kufuta records zote kwenye table.

Kwa hiyo matumizi ya WHERE ni muhimu sana.

4. Tutumie Table ya Students

Fikiria tuna table:

CREATE TABLE students (
    student_id INT PRIMARY KEY AUTO_INCREMENT,
    student_name VARCHAR(100),
    gender VARCHAR(10),
    age INT,
    phone_number VARCHAR(20),
    class_name VARCHAR(50)
);

Ingiza data:

INSERT INTO students (
    student_name,
    gender,
    age,
    phone_number,
    class_name
)
VALUES
('Asha Mussa', 'Female', 16, '0711111111', 'Form One'),
('John Peter', 'Male', 17, '0722222222', 'Form Two'),
('Neema Joseph', 'Female', 15, '0733333333', 'Form One'),
('Peter Michael', 'Male', 18, '0744444444', 'Form Three'),
('Anna Charles', 'Female', 17, '0755555555', 'Form Two');

5. Kuangalia Record Kabla ya DELETE

Kabla ya kufuta, ni vizuri kufanya:

SELECT *
FROM students
WHERE student_id = 3;

Hakikisha record uliyoiona ndiyo unayotaka kufuta.

Kisha:

DELETE FROM students
WHERE student_id = 3;

6. Kuangalia Baada ya DELETE

Baada ya kufuta:

SELECT *
FROM students;

Student mwenye ID 3 hatapaswa kuonekana tena.

7. Kufuta Record kwa Primary Key

Primary Key ndiyo njia nzuri ya kulenga record moja.

Mfano:

DELETE FROM students
WHERE student_id = 4;

Kwa sababu student_id ni unique, record moja tu ndiyo inalengwa.

8. Kufuta kwa Jina

Unaweza kuandika:

DELETE FROM students
WHERE student_name = 'Asha Mussa';

Lakini hii inaweza kuwa hatari ikiwa kuna students wawili wenye jina moja.

Kwa hiyo mara nyingi:

WHERE student_id = ...

ni bora zaidi.

9. Kufuta Records Nyingi

DELETE inaweza kufuta records nyingi ikiwa condition inalingana na records nyingi.

Mfano:

DELETE FROM students
WHERE class_name = 'Form One';

Hii inaweza kufuta students wote wa Form One.

10. DELETE na AND

Mfano:

DELETE FROM students
WHERE gender = 'Male'
AND age < 16;

Hii itafuta students ambao:

• Ni Male
• Na age yao ni chini ya 16

Conditions zote mbili lazima zitimie.

11. DELETE na OR

Mfano:

DELETE FROM students
WHERE student_id = 2
OR student_id = 5;

Hii inaweza kufuta records mbili.

12. DELETE na NOT

Mfano:

DELETE FROM students
WHERE NOT class_name = 'Form Two';

Hii inaweza kufuta students ambao si Form Two.

Query kama hii inaweza kuathiri records nyingi, hivyo lazima itumike kwa uangalifu mkubwa.

13. Hatari ya DELETE Bila WHERE

Query hii:

DELETE FROM students;

inaweza kufuta records zote.

Table yenyewe bado itabaki.

Structure ya table inaweza kubaki kama:

student_id
student_name
gender
age
phone_number
class_name

lakini data yote inaweza kuondolewa.

14. DELETE Haifuti Table Structure

Hii:

DELETE FROM students;

inafuta data.

Lakini table bado ipo.

Unaweza kuangalia:

DESC students;

Structure bado itaonekana.

15. DELETE Record Moja

Mfano:

DELETE FROM students
WHERE student_id = 1;

Hii ni matumizi ya kawaida sana.

16. DELETE Katika Table ya Marks

Tutengeneze:

CREATE TABLE marks (
    mark_id INT PRIMARY KEY AUTO_INCREMENT,
    student_name VARCHAR(100),
    subject VARCHAR(100),
    score DECIMAL(5,2)
);

Data:

INSERT INTO marks (
    student_name,
    subject,
    score
)
VALUES
('Asha Mussa', 'Mathematics', 85),
('John Peter', 'Mathematics', 42),
('Neema Joseph', 'English', 91),
('Peter Michael', 'Physics', 55);

17. Kufuta Mark Moja

DELETE FROM marks
WHERE mark_id = 2;

Hii itafuta record yenye mark_id = 2.

18. Kufuta Marks za Subject Fulani

DELETE FROM marks
WHERE subject = 'Physics';

Hii inaweza kufuta records zote za Physics.

Kabla ya kufanya hivyo, angalia:

SELECT *
FROM marks
WHERE subject = 'Physics';

19. Kufuta Marks Chini ya 20

DELETE FROM marks
WHERE score < 20;

Hii inaweza kuondoa records zote zenye score chini ya 20.

Lakini katika mfumo halisi wa matokeo, kufuta marks kwa condition kama hii si jambo la kufanya bila sababu nzuri.

20. DELETE Katika Products Table

Fikiria tuna:

CREATE TABLE products (
    product_id INT PRIMARY KEY AUTO_INCREMENT,
    product_name VARCHAR(100),
    category VARCHAR(100),
    price DECIMAL(10,2),
    quantity INT
);

21. Kufuta Product

DELETE FROM products
WHERE product_id = 5;

22. Kufuta Products za Category Fulani

DELETE FROM products
WHERE category = 'Old Products';

Hii inaweza kufuta records nyingi.

Kabla ya kufanya hivyo:

SELECT *
FROM products
WHERE category = 'Old Products';

23. DELETE na Comparison Operators

Unaweza kutumia:

=
>
<
>=
<=
!=
<>

Mfano:

DELETE FROM products
WHERE quantity = 0;

Hii inaweza kufuta products zisizo na stock.

Lakini kwenye mfumo halisi unaweza kutaka kuweka status inactive badala ya kufuta record kabisa.

24. Soft Delete ni Nini?

Badala ya kufuta record kabisa, mifumo mingi hutumia concept inayoitwa:

Soft Delete

Mfano table ina column:

status VARCHAR(20) DEFAULT 'Active'

Badala ya:

DELETE FROM students
WHERE student_id = 5;

unaweza kufanya:

UPDATE students
SET status = 'Inactive'
WHERE student_id = 5;

Record bado ipo lakini haionekani kama active.

Hii inaweza kuwa useful kwenye systems zinazohitaji history.

25. Kwa Nini Soft Delete Inaweza Kuwa Bora?

Soft delete inaweza kusaidia:

• Kuweka history
• Kurudisha record baadaye
• Kuepuka data loss
• Kufuatilia activities
• Kuweka audit trail

Lakini matumizi yake yanategemea design ya mfumo.

26. DELETE na Foreign Keys

Fikiria tuna:

students
marks

na marks.student_id ina Foreign Key kwenda students.student_id.

Ukijaribu kufuta student ambaye ana marks:

DELETE FROM students
WHERE student_id = 3;

MySQL inaweza kukataa ikiwa Foreign Key constraint haijaruhusu deletion.

Unaweza kupata error inayohusiana na:

foreign key constraint

Tutajifunza Foreign Keys kwa undani katika somo lake.

27. ON DELETE CASCADE

Katika advanced relationships unaweza kukutana na:

ON DELETE CASCADE

Hii inaweza kufanya child records zifutwe automatically parent record inapofutwa.

Mfano:

Student akifutwa, marks zake nazo zinaweza kufutwa.

Hii ni powerful lakini inapaswa kutumika kwa uangalifu mkubwa.

Tutajifunza vizuri zaidi kwenye Foreign Key.

28. DELETE na LIMIT

MySQL inaweza kuruhusu:

DELETE FROM students
WHERE class_name = 'Form One'
LIMIT 1;

Hii inaweza kufuta record moja tu inayolingana.

Lakini kwa data muhimu, ni bora kutumia Primary Key kuliko kutegemea LIMIT.

29. DELETE na ORDER BY

Katika single-table DELETE, MySQL inaweza pia kuruhusu matumizi ya ORDER BY pamoja na LIMIT.

Mfano:

DELETE FROM logs
ORDER BY log_id ASC
LIMIT 100;

Hii inaweza kutumika kwenye cleanup ya old logs.

Lakini kwa beginners, elewa kwanza DELETE kwa WHERE na Primary Key.

30. Workflow Salama ya DELETE

Njia nzuri ni:

1. SELECT
2. Hakikisha records
3. DELETE
4. SELECT tena

Mfano:

SELECT *
FROM students
WHERE student_id = 5;

Kisha:

DELETE FROM students
WHERE student_id = 5;

Halafu:

SELECT *
FROM students
WHERE student_id = 5;

31. SELECT Kabla ya Mass DELETE

Fikiria unataka kufuta records:

DELETE FROM products
WHERE quantity = 0;

Kwanza:

SELECT *
FROM products
WHERE quantity = 0;

Angalia records zitakazoathirika.

Kisha ndiyo ufanye DELETE.

32. Backup Kabla ya DELETE Kubwa

Ikiwa unafanya kazi na database muhimu, backup ni muhimu kabla ya kufuta records nyingi.

Kwa sababu DELETE inaweza kusababisha permanent data loss ikiwa huna backup au transaction ya kurejesha.

33. DELETE na Transactions

Baadaye tutajifunza:

START TRANSACTION;

ROLLBACK;

na:

COMMIT;

Hizi zinaweza kusaidia wakati wa kufanya operations muhimu.

Mfano wa concept:

START TRANSACTION;

DELETE FROM students
WHERE student_id = 5;

ROLLBACK;

ROLLBACK inaweza kurudisha mabadiliko ikiwa transaction haijacommitiwa na storage engine/support inaruhusu.

Tutajifunza Transactions kwa undani baadaye.

34. Makosa ya Kawaida – Kusahau FROM

Mfano mbaya:

DELETE students
WHERE student_id = 2;

Syntax ya kawaida tunayojifunza ni:

DELETE FROM students
WHERE student_id = 2;

35. Makosa ya Kawaida – Kusahau WHERE

Mfano:

DELETE FROM students;

Hii inaweza kufuta records zote.

Kama ulikusudia record moja, hilo ni kosa kubwa.

36. Makosa ya Kawaida – Wrong ID

Mfano:

DELETE FROM students
WHERE student_id = 8;

lakini ulikusudia:

student_id = 6

Query inaweza kuwa syntactically correct lakini ikafuta record isiyo sahihi.

Kwa hiyo SELECT kwanza.

37. Makosa ya Kawaida – Kutumia Jina Badala ya ID

Mfano:

DELETE FROM students
WHERE student_name = 'John Peter';

Ikiwa kuna John Peter zaidi ya mmoja, wote wanaweza kufutwa.

Bora:

DELETE FROM students
WHERE student_id = 7;

38. Makosa ya Kawaida – Condition Kubwa Sana

Mfano:

DELETE FROM students
WHERE age >= 16;

Hii inaweza kufuta sehemu kubwa ya students.

Kabla ya DELETE:

SELECT *
FROM students
WHERE age >= 16;

39. DELETE vs UPDATE

UPDATE hubadilisha data:

UPDATE students
SET class_name = 'Form Two'
WHERE student_id = 3;

DELETE huondoa record:

DELETE FROM students
WHERE student_id = 3;

40. DELETE vs DROP

DELETE:

DELETE FROM students;

inafuta records lakini table inabaki.

DROP TABLE:

DROP TABLE students;

inaondoa table yenyewe pamoja na structure yake.

Hii ni tofauti kubwa.

41. DELETE vs TRUNCATE

DELETE:

DELETE FROM students;

inafuta records.

TRUNCATE:

TRUNCATE TABLE students;

pia huondoa records zote, lakini hufanya hivyo kwa njia tofauti na DELETE.

Kwa mfano, kwa matumizi ya kawaida:

• DELETE inaweza kutumia WHERE
• TRUNCATE haiwezi kutumia WHERE
• TRUNCATE inalenga table nzima

Tutajifunza tofauti hizi kwa undani zaidi katika somo la DROP, DELETE na TRUNCATE.

42. DELETE Inaweza Kutumia WHERE

Mfano:

DELETE FROM students
WHERE student_id = 3;

Lakini huwezi kufanya:

TRUNCATE TABLE students
WHERE student_id = 3;

Hiyo si matumizi sahihi ya TRUNCATE.

43. DELETE Katika User System

Fikiria table:

users

Admin anaweza kufuta user:

DELETE FROM users
WHERE user_id = 7;

Lakini kwenye systems nyingi ni bora kuweka:

status = inactive

ili kuweka history.

44. DELETE Katika Blog System

Admin anaweza kufuta post:

DELETE FROM posts
WHERE post_id = 10;

Kabla yake:

SELECT *
FROM posts
WHERE post_id = 10;

45. DELETE Katika Accounting System

Katika accounting systems, kufuta payment au contribution record kunaweza kuwa sensitive.

Badala ya kufuta kabisa, mfumo unaweza kutumia:

voided
cancelled
inactive

ili history ibaki.

Database design inapaswa kuzingatia audit trail.

46. DELETE Katika Student Management System

Kwa registration data, unaweza kuamua student asifutwe kabisa.

Badala yake:

UPDATE students
SET status = 'Inactive'
WHERE student_id = 20;

Hii inaweza kuwa salama zaidi kuliko:

DELETE FROM students
WHERE student_id = 20;

47. Referential Integrity

Ukifuta record ambayo records nyingine zinaitumia, unaweza kuvunja relationship ikiwa database haijaundwa vizuri.

Mfano:

students
marks
payments
attendance

Student anaweza kuwa referenced kwenye tables zote hizi.

Ndiyo maana design ya Foreign Keys ni muhimu.

48. DELETE na Date

Fikiria table ya logs:

CREATE TABLE logs (
    log_id INT PRIMARY KEY AUTO_INCREMENT,
    message VARCHAR(255),
    created_at DATETIME
);

Unaweza kufuta old logs:

DELETE FROM logs
WHERE created_at < '2025-01-01';

Lakini hakikisha tarehe na records unazolenga ni sahihi.

49. DELETE Old Records kwa Usalama

Kwanza:

SELECT *
FROM logs
WHERE created_at < '2025-01-01';

Kisha:

DELETE FROM logs
WHERE created_at < '2025-01-01';

50. DELETE na NULL

Unaweza kufuta records ambazo column fulani ni NULL kwa kutumia:

DELETE FROM students
WHERE phone_number IS NULL;

Kumbuka:

phone_number = NULL

si njia sahihi ya kawaida ya ku-test NULL.

Tunatumia:

IS NULL

51. DELETE na IS NOT NULL

Mfano:

DELETE FROM temporary_contacts
WHERE phone_number IS NOT NULL;

Hii inaweza kufuta records zenye phone number.

Query kama hii inaweza kuathiri records nyingi, hivyo tumia kwa umakini.

52. SQL Safe Update Mode

Baadhi ya tools kama MySQL Workbench zinaweza kuwa na:

Safe Update Mode

ambayo inaweza kuzuia DELETE au UPDATE zinazoweza kuathiri records nyingi bila key condition.

Hii ni protection nzuri kwa beginners.

Usizime protection bila kuelewa kwa nini query yako imezuiwa.

53. DELETE Haipunguzi AUTO_INCREMENT Automatically kwa Njia Unayotarajia

Fikiria una IDs:

1
2
3
4
5

Ukifuta ID 5:

DELETE FROM students
WHERE student_id = 5;

kisha ukaongeza student mpya, mara nyingi AUTO_INCREMENT itaendelea na value inayofuata badala ya kutumia ID 5 tena.

Mfano inaweza kuwa:

6

54. Gaps katika IDs ni Kawaida

Baada ya deletes unaweza kuwa na:

1
2
4
7
8

Hili si tatizo.

Primary Key haitakiwi kuwa sequence isiyo na gaps.

Kazi yake kuu ni kuwa identifier unique.

55. Usibadilishe IDs kwa Sababu Tu Kuna Gaps

Usijaribu kupanga upya Primary Keys kila baada ya DELETE.

Hii inaweza kusababisha matatizo kwenye Foreign Keys na relationships.

ID ni identifier, si position number.

56. DELETE Record Moja kwa Workflow Kamili

Angalia:

SELECT *
FROM students
WHERE student_id = 4;

Futa:

DELETE FROM students
WHERE student_id = 4;

Thibitisha:

SELECT *
FROM students
WHERE student_id = 4;

57. DELETE Records Nyingi kwa Workflow Kamili

Angalia:

SELECT *
FROM students
WHERE class_name = 'Form Three';

Kama umehakikisha:

DELETE FROM students
WHERE class_name = 'Form Three';

Kisha:

SELECT *
FROM students
WHERE class_name = 'Form Three';

58. Mfano wa Products

Kwanza:

SELECT *
FROM products
WHERE quantity = 0;

Kisha, kama kweli unataka kufuta:

DELETE FROM products
WHERE quantity = 0;

59. Mfano wa Temporary Data

DELETE inaweza kuwa useful sana kwa temporary tables.

Mfano:

DELETE FROM temporary_users
WHERE status = 'Expired';

60. Query Order ya DELETE

Kwa matumizi ya msingi:

DELETE FROM table_name
WHERE condition;

Mfano:

DELETE FROM students
WHERE student_id = 10;

61. Je Tunaweza Kutumia SELECT na DELETE Pamoja?

Si kwa syntax rahisi kama:

SELECT DELETE

Kawaida tunafanya:

SELECT *
FROM students
WHERE student_id = 10;

halafu:

DELETE FROM students
WHERE student_id = 10;

Hii ndiyo workflow nzuri kwa beginner.

62. DELETE Katika Mfumo wa PHP

Baadaye kwenye PHP unaweza kuwa na button ya:

Delete

User akibofya, system inaweza kutuma ID ya record.

Concept ya SQL:

DELETE FROM students
WHERE student_id = ?;

Hapa:

?

inaweza kutumika na prepared statement.

Hii ni salama zaidi kuliko kuchanganya raw user input moja kwa moja kwenye SQL.

63. Confirmation Kabla ya DELETE

Katika web application ni vizuri kuwa na confirmation kama:

Are you sure you want to delete this record?

Hii husaidia kuzuia accidental deletion.

Lakini confirmation ya frontend pekee haitoshi; backend pia lazima ithibitishe ID na permissions.

64. Permissions ni Muhimu

Si kila user anapaswa kuruhusiwa kufanya:

DELETE

Mfano:

• Student anaweza kuona taarifa
• Teacher anaweza ku-edit marks
• Admin pekee anaweza kufuta records fulani

Hii ni sehemu ya access control.

65. Audit Trail

Kwa systems kubwa, unaweza kuhifadhi taarifa kama:

deleted_by
deleted_at
reason

Badala ya kufuta record moja kwa moja.

Mfano:

UPDATE students
SET
    status = 'Deleted',
    deleted_at = CURRENT_TIMESTAMP
WHERE student_id = 10;

Hii ni mfano wa soft delete.

66. DELETE vs Soft Delete

Hard delete:

DELETE FROM students
WHERE student_id = 10;

Record inaondolewa.

Soft delete:

UPDATE students
SET status = 'Inactive'
WHERE student_id = 10;

Record inabaki lakini haitumiki kama active.

67. Ni Wakati Gani DELETE Inafaa?

DELETE inaweza kufaa kwa:

• Test data
• Temporary data
• Duplicate records baada ya verification
• Old logs
• Records ambazo policy inaruhusu kuondolewa
• Data iliyoongezwa kimakosa

Lakini kwa records za kifedha, academic history au audit records, deletion inahitaji design ya makini zaidi.

68. Workflow Yetu Mpaka Sasa

Tumeshajifunza concepts kama:

CREATE DATABASE
CREATE TABLE
PRIMARY KEY
AUTO_INCREMENT
INSERT
SELECT
WHERE
AND
OR
NOT
ORDER BY
LIMIT
OFFSET
UPDATE
DELETE

Sasa tuna msingi muhimu wa CRUD.

69. CRUD ni Nini?

CRUD ni kifupi cha:

C = Create
R = Read
U = Update
D = Delete

Katika MySQL:

Create:

INSERT INTO

Read:

SELECT

Update:

UPDATE

Delete:

DELETE

Hizi ni operations muhimu sana kwenye applications.

70. Mfano wa CRUD kwa Students

Create:

INSERT INTO students (
    student_name,
    gender,
    age
)
VALUES (
    'Asha Mussa',
    'Female',
    16
);

Read:

SELECT *
FROM students
WHERE student_id = 1;

Update:

UPDATE students
SET age = 17
WHERE student_id = 1;

Delete:

DELETE FROM students
WHERE student_id = 1;

71. Mazoezi ya Somo

Tumia table ya students.

Fanya yafuatayo:

1. Chagua student ID 2.
2. Futa student ID 2.
3. Hakikisha amefutwa.
4. Chagua students wa Form Three.
5. Futa student mmoja kwa Primary Key.
6. Andika query ya kufuta Male students wenye age chini ya 16.
7. Andika query ya kufuta records zenye phone_number NULL.
8. Eleza kwa nini DELETE bila WHERE ni hatari.

72. Challenge ya Somo

Tengeneza table:

products

yenye:

product_id
product_name
category
price
quantity

Ingiza products angalau 8.

Kisha:

1. Futa product ID 2.
2. Futa product ID 5.
3. Chagua products zenye quantity 0.
4. Futa products zenye quantity 0.
5. Chagua products za category Old Stock.
6. Futa records hizo baada ya verification.
7. Angalia products zote baada ya deletion.
8. Angalia kama IDs zina gaps.

73. Challenge ya Usalama

Fikiria unataka kufanya:

DELETE FROM students
WHERE class_name = 'Form One';

Kabla ya kufanya DELETE, andika query ya verification.

Jibu:

SELECT *
FROM students
WHERE class_name = 'Form One';

Baada ya kuhakikisha ndipo unaweza kutumia DELETE.

74. Maswali ya Kujipima

Jaribu kujibu:

1. DELETE inatumika kufanya nini?
2. Syntax ya DELETE ni ipi?
3. Kwa nini WHERE ni muhimu?
4. Nini hutokea kwa DELETE FROM students;?
5. Je table structure inafutwa na DELETE?
6. Kwa nini Primary Key ni nzuri kwenye DELETE?
7. Kuna tofauti gani kati ya DELETE na DROP?
8. Kuna tofauti gani kati ya DELETE na TRUNCATE?
9. Soft delete ni nini?
10. Kwa nini ni vizuri kufanya SELECT kabla ya DELETE?
11. Je gaps kwenye AUTO_INCREMENT IDs ni tatizo?
12. CRUD ina maana gani?

75. Muhtasari wa Somo

Katika somo hili tumejifunza kutumia:

DELETE FROM

kufuta records.

Mfano:

DELETE FROM students
WHERE student_id = 3;

Tumejifunza umuhimu wa:

WHERE

kwa kulenga records maalumu.

Pia tumeona workflow salama:

SELECT
↓
Verify
↓
DELETE
↓
SELECT tena

Tumejifunza kuwa:

DELETE FROM students;

inaweza kufuta records zote.

Na pia tumegusa tofauti kati ya:

DELETE
DROP
TRUNCATE

pamoja na concept ya:

Soft Delete

Sasa tunaelewa vizuri operations nne muhimu za CRUD:

CREATE
READ
UPDATE
DELETE

Somo Linalofuata

Katika Somo la 16 tutajifunza:

LIKE na Wildcards – Jinsi ya Kutafuta Data kwa Majina au Maneno Katika MySQL

Tutajifunza:

• LIKE
• %
• _
• Kutafuta jina linaloanza na herufi fulani
• Kutafuta jina linaloishia na herufi fulani
• Kutafuta neno lililopo katikati
• Search ya student names
• Search ya products
• Search ya blog posts
• NOT LIKE
• Kuchanganya LIKE na WHERE
• Kuchanganya LIKE na AND/OR
• Makosa ya kawaida
• Mazoezi ya search queries

Hapo tutaanza kujifunza searching ya text ndani ya MySQL.