How can I create a small relational database in MySQL?
- by Sergio Tapia
I need to make a small database in MySQL that has two tables.
Clothes and ClotheType
Clothes has: ID, Name, Color, Brand, Price, ClotheTypeID
ClotheType has: ID, Description
In Microsoft SQL it would be:
create table Clothes(
id int,
primary key(id),
name varchar(200),
color varchar(200),
brand varchar(200),
price varchar(200),
clothetypeid int,
foreign key clothetypeid references ClotheType(id)
)
I need this in MySQL.