Jinsi ya Kutumia INSERT, UPDATE, DELETE

Kwenye MySQL, INSERT, UPDATE, DELETE ni SQL statements muhimu zinazotumika kuingiza, kubadilisha, na kufuta data kwenye tables.
Kujua jinsi ya kutumia hizi statements ni msingi wa database management.

🔹 1. INSERT – Kuingiza Data

INSERT INTO hutumika kuongeza records mpya kwenye table.

Mfano: Kuongeza students

INSERT INTO students (name, email, age, class_id)
VALUES ('Asha', 'asha@example.com', 16, 1);


students – jina la table

(name, email, age, class_id) – columns

VALUES – data unayoingiza

Multiple records

INSERT INTO students (name, email, age, class_id)
VALUES
('Faustine', 'faustine@example.com', 17, 2),
('John', 'john@example.com', 15, 1);

🔹 2. UPDATE – Kubadilisha Data

UPDATE hutumika kubadilisha records zilizopo kwenye table.

Mfano: Kubadilisha age ya student

UPDATE students
SET age = 18
WHERE name = 'Asha';

🔹 Maelezo:

SET – column unayobadilisha na value mpya

WHERE – hufafanua record gani kubadilisha (hakikisha using WHERE ni muhimu!)

Update multiple fields

UPDATE students
SET age = 18, email = 'asha_new@example.com'
WHERE id = 1;

🔹 3. DELETE – Kufuta Data

DELETE FROM hutumika kufuta records zilizopo.

Mfano: Kufuta student fulani

DELETE FROM students
WHERE name = 'John';


Futa multiple records

DELETE FROM students
WHERE class_id = 1;


💡 Tahadhari: Kutumia DELETE bila WHERE kunafuta records zote kwenye table.

🔹 4. Vidokezo Muhimu

Always backup data kabla ya UPDATE/DELETE.

Tumia WHERE clause ili kuepuka kuathiri records zote kwa bahati mbaya.

INSERT inaweza kuingiza record moja au nyingi kwa wakati mmoja.

UPDATE inaweza kubadilisha single field au multiple fields.

DELETE ni final operation, hakikisha unataka kufuta data.

🌐 Soma Zaidi

Kwa mafunzo zaidi kuhusu MySQL CRUD operations, tembelea https://www.faulink.com/
.
Utajifunza jinsi ya kushughulikia data, kuunda forms, na kuunda database management systems kwa vitendo.

📘 Hitimisho

INSERT, UPDATE, DELETE ni misingi ya kushughulikia data katika MySQL.

INSERT – kuongeza data mpya

UPDATE – kubadilisha data iliyopo

DELETE – kufuta data iliyopo

Kwa kutumia hizi commands kwa uangalifu, unaweza kusimamia database yako kwa ufanisi na usalama.