#データベースの一覧を表示
show databases;

#データベースを選択する
\u データベース名

create database goods;

#データベース内にあるテーブル一覧
show tables;

create table personal(id int, name varchar(20));

insert into personal(id, name) values(1, '阿部 太郎');
insert into personal(id, name) values(2, '佐藤 恵子');

INSERT INTO goods (id, name) VALUES (1, '花瓶'), (2, '財布'), (3, '時計');

SELECT * FROM personal;
SELECT * FROM goods;

#終了(ログアウト)
\q

#---------------
CREATE TABLE staff (id SMALLINT NOT
NULL, name VARCHAR(20), age TINYINT, bid
SMALLINT);





INSERT INTO staff VALUES 
('1', '佐藤','23', '1');

INSERT INTO staff VALUES 
('2', '鈴木','24', '2'), 
('3', '高橋', '28', '1');

INSERT INTO staff (id, name) VALUES
('9', 'Kobayashi');

SELECT * FROM staff;

SELECT name as '名前' ,age as '年齢' FROM
staff;

SELECT bid,COUNT(name) as '人数' FROM staff
GROUP BY bid;

CREATE TABLE members 
(name VARCHAR(20), address VARCHAR(50),
age TINYINT);

INSERT INTO members 
(name,address,age ) VALUES
('Sato' , 'Tokyo' , 23);

SELECT * FROM members;