SQL Database

[Welcome Guest]

Mga master, ano po ang sql neto?
1.) "Set the fname and lname of instructor A B to C D"
2.) "Remove from student table the student with fname A and lname B"

Ganito ko ginagawa ko pero parang hindi maganda kasi humahaba at parang mali rin ang query ko dahil one query lng dapat sya...

My Code 1:

UPDATE instructor SET fname = 'A' WHERE instructor_num = '1';
UPDATE instructor SET lname = 'B' WHERE instructor_num = '1';

UPDATE instructor SET fname = 'C' WHERE instructor_num = '1';
UPDATE instructor SET lname = 'D' WHERE instructor_num = '1';

My Code 2:
DELETE FROM student WHERE fname = 'A' & lname = 'B'

 

[vhin le]

UPDATE instructor SET fname = 'A', lname='B' WHERE instructor_num = 1;
DELTE FROM Student WHERE fname = 'A' AND lname='B';

 

[Welcome Guest]

UPDATE instructor SET fname = 'A', lname='B' WHERE instructor_num = 1;
DELTE FROM Student WHERE fname = 'A' AND lname='B';

Salamat po hehe

 

[LocalHost 8080]

UPDATE instructor SET fname = 'C', lname='D' WHERE fname='A' AND lname='B'

ang sabi po kasi papalitan daw ang name ni instructor A B ng C D

 

[sinner231_100]

update instructor set fname = 'C', lname = 'D'
where fname = 'A' and lname = 'B'

delete student where fname = 'A' and lname = 'B'