create database PhoneBook;

use PhoneBook;

create table Employees (
empid char(10) not null,
lastname char(30) not null,
firstname char(20) not null,
deptno char(4) not null,
title char(30),
email char(25),
phone char(8),
fax char(8),
primary key(empid) )
;

create table Departments (
deptno char(4) not null,
deptname char(30) not null,
address char(40),
city char(25),
state char(2),
zip char(5),
areacode char(3),
manager char(8),
primary key(deptno) )
;

show tables;

show columns from Employees;

insert into Employees (
empid,lastname,firstname,deptno,title,email,phone)
values ("556219","Scuz","Joe","2318","Auditor","jscuz@us.com","555-1212")
;

show columns from Departments;

insert into Departments (
deptno,deptname,address,city,state,zip,areacode)
values ("2318","Audit","25 Loser Ln.","Dorksville","CA","90210","213")
;

select * from Employees;

grant all on *.* to root@"%";