UPDATE DATA MENGGUNAKAN SQL

CREATE TABLE krs (nim char(10),kode char(10),nip char(10),uts int(50),uas int(50),akhir float,huruf char(10),bobot char(10));

1. Field Akhir = (40/100*uts)+(60/100*uas)

2.Field Huruf =

         A : >= 85

         B : 75-85

         C : 60-74

         D : 40-59 

         E : < 40

3.Field Bobot =

         A : 4

         B : 3

         C : 2

         D : 1

         E : 0

Sql nya adalah :

1.UPDATE krs SET akhir  = ‘(40/100*uts)+(60/100*uas)’;

2.UPDATE krs SET huruf = “A” WHERE akhir >=85;

   UPDATE krs SET huruf = “B” WHERE (akhir < 85)&&(akhir >=75);

   UPDATE krs SET huruf = “C” WHERE (akhir < 75)&&(akhir >=60);

   UPDATE krs SET huruf = “D” WHERE (akhir < 60)&&(akhir >=40);

   UPDATE krs SET huruf = “E” WHERE akhir < 40;

3. UPDATE krs SET bobot = “4” WHERE huruf = “A”;

   UPDATE krs SET bobot = “3” WHERE huruf = “B”;

   UPDATE krs SET bobot = “2” WHERE huruf = “C”;

   UPDATE krs SET bobot = “1” WHERE huruf = “D”;

   UPDATE krs SET bobot = “0” WHERE huruf = “E ”;