fZ0NKaRV

1create DATABASE if not EXISTS bancox;
2use bancox;
3create table cliente(
4    cpf varchar(11) PRIMARY KEY,
5    nome varchar(50),
6    data_nasc DATE,
7    agencia varchar(50),
8    num_conta varchar(50) UNIQUE,
9    rg varchar(15),
10    saldo decimal(10,2),
11    endereco varchar(50),
12    cidade varchar(50)
13);
14
15
16INSERT INTO `cliente` (`cpf`, `data_nasc`, `agencia`, `num_conta`, `rg`, `saldo`, `endereco`, `cidade`, `nome`) VALUES
17('06245233577', '1993-05-22', '1234-22', '123456', 'RG: 1234567', '200.00', 'AV X, Bairoo X', 'VCA', 'Jean Leal Silva'),
18('29312782622', '1997-06-06', '1234-22', '129738217', 'RG: 12314314', '1000.00', 'AV X, Bairoo X', 'PLA', 'Roberta Santos'),
19('32916220143', '1993-12-01', '1224-22', '727338383', 'RG: 273784848', '4000.00', 'AV X, Bairoo X', 'IBO', 'Junior Souza'),
20('80404847820', '1992-01-22', '1234-22', '17387832', 'RG: 12345678', '300.00', 'AV X, Bairoo X', 'VCA', 'Daniel Prado');
21
22create view view_caixa as select cpf, nome, saldo from cliente;
23
24select * from view_caixa where cpf = "06245233577";