Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database bdAgenciaCarro;
- use bdAgenciaCarro;
- create table tbContato(
- idContato int primary key auto_increment
- ,nomeContato varchar(40)
- ,emailContato varchar(60)
- ,assuntoContato varchar (120)
- ,msgContato varchar(40)
- );
- insert into tbContato values(null,'João','joao@gmail.com','Tit mensagem','tx mensagem');
- create table tbMarca(
- idMarca int primary key auto_increment
- ,marca varchar(60)
- );
- insert into tbMarca values(null,'Hyundai');
- insert into tbMarca values(null,'Honda');
- insert into tbMarca values(null,'Volkswagen');
- insert into tbMarca values(null,'Fiat');
- select * from tbContato;
- create table tbVeiculo(
- idVeiculo int primary key auto_increment
- ,modelo varchar(40)
- ,idMarca int
- ,valor float
- ,foreign key (idMarca) references tbMarca(idMarca)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement