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