1create table categories(
2cat_id int not null primary key,
3cat_name varchar(255) not null,
4cat_description text
5) engine=innodb;
6create table products(
7prd_id int not null auto_increment primary key,
8prd_name varchar(355) not null,
9prd_price decimal,
10cat_id int not null,
11foreign key fk_cat(cat_id)
12references categories(cat_id)
13on update cascade
14) engine=innodb;
15insert into categories values (1, 'drinks', 'drinks');
16update categories set cat_description=2 where cat_id=1;
17drop table products, categories;
18