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;