ecommerce database seri 2: products table #shortsfeed #mysql

use ecommerce;

show tables;

create table products (
id int primary key auto_increment,
nama varchar(100) not null,
harga decimal(10,2) not null,
stok int default 0
);

show tables;

insert into products (nama, harga, stok)
values
('Kaos Polos',75000,50),
('Celana Jenas',185000,30),
('Sepatu Kasual',250000,20);

SELECT * FROM products;

#shorts #database #databasedesign #mysql #ecommerce

Видео ecommerce database seri 2: products table #shortsfeed #mysql канала Saifi Ahmada