Database and Terminal nice to know commands

8. February 2019

Login: mysql -u root -p

1	Login: mysql -u root -p

Show db/db's: show databases;

1	Show db/db's: show databases;

Select a DB: use mysql;

1	Select a DB: use mysql;

List tables: show tables;

1	List tables: show tables;

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

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

Exit: exit

1	Exit: exit

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

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

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