Scribd
Upload
37 views1 page

Tugas: / SOAL

The document contains instructions for updating data and modifying database and table structures. It includes commands to: 1) Update price fields for specific items in the "barang" table 2) Add and modify a field to the "barang" table 3) Create, populate, and drop a sample "coba" database and table for testing purposes

Uploaded by

Xm3 T7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
37 views1 page

Tugas: / SOAL

The document contains instructions for updating data and modifying database and table structures. It includes commands to: 1) Update price fields for specific items in the "barang" table 2) Add and modify a field to the "barang" table 3) Create, populate, and drop a sample "coba" database and table for testing purposes

Uploaded by

Xm3 T7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

TUGAS

 SELECT * FROM barang

/*SOAL*/
 UPDATE barang set Harga_Beli ='10000' WHERE id='B10' /*1*/
 UPDATE barang set Harga_Jual ='4000' WHERE id='B03' /*2*/
 UPDATE barang set Harga_Jual ='15000' WHERE id='B09' /*3*/
 UPDATE barang set Harga_Beli ='14000' WHERE id='B09' /*3*/
 ALTER TABLE barang ADD Produksi char<15> /*4*/
 ALTER TABLE barang CHANGE Produksi INT /*5*/
 CREATE DATABASE COBA_DROP /*6*/
 CREATE TABLE coba_drop <Coba_Drop CHAR <10>> /*7*/
 DROP TABLE coba_drop /*8*/
 DROP DATABASE coba_drop /*9*/

/*TUGAS*/

 UPDATE barang SET Harga_Beli ='10500' WHERE ID ='B01' /*1*/


 UPDATE barang set Harga_Jual ='15000' WHERE id='B03' /*2*/
 UPDATE barang set Harga_Beli ='14000' WHERE id='B03' /*3*/
 ALTER TABLE barang ADD Produksi CHAR<15> /*4*/
 UPDATE barang set Produksi ='Top' WHERE id='B01' /*5*/
 CREATE DATABASE COBA; /*6*/
 USE COBA; /*6*/
 CREATE TABLE coba < coba CHAR <15> not NULL PRIMARY KEY> /*6*/
 DROP TABLE coba; /*7*/
 drop DATABASE coba; /*7*/

You might also like