My first Database

Create table:

create table stok ( 
     id int(11) not null PRIMARY KEY AUTO_INCREMENT, 
     quantity int(11) not null, 
     symbol varchar(128) not null, 
     cost int(11) not null, 
     currency varchar(128) not null 
);

 

Inset value to DB:

insert into stok (quantity, symbol, cost, currency) VALUES ('10', 'SNAP', '8', 'USD');

 

Leave a Reply

Your email address will not be published. Required fields are marked *