• Blog & Tutorials
• MySQL

Database and Terminal nice to know commands

8. February 2019

Login: mysql -u root -p

Show db/db's: show databases;

Select a DB: use mysql;

List tables: show tables;

Show users: select user, host from mysql.user;

Exit: exit

• Blog & Tutorials
• MySQL

My first Database

28. June 2018

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');