SHOW DATABASES;

CREATE DATABASE db_penjualan;

USE db_penjualan;

CREATE TABLE data_barang(kd_barang char(5)not null, nm_barang varchar(20)not null, harga int, jumlah int, PRIMARY KEY(kd_barang));

INSERT INTO data_barang VALUES 

('B001','Buku Tulis','1000','150'),

('B005','Buku Gambar','2000','15');

ALTER TABLE data_barang MODIFY harga BIGINT(12)NOT NULL;

ALTER TABLE data_barang CHANGE jumlah stock VARCHAR(3);

SELECT * FROM data_barang;     

DESC data_barang;    

SELECT nm_barang as 'Nama Barang', harga, stock FROM data_barang;