SQLize Online / PHPize Online  /  SQLtest Online

create table dish_order( d_id int(3) not null references dish(d_id), o_id int(3) not null references order_(o_id), count_ int(3) not null ); describe dish_order; insert into dish_order(d_id,o_id,count_) values (1,1,2); insert into dish_order(d_id,o_id,count_) values (1,2,2); insert into dish_order(d_id,o_id,count_) values (1,4,2); insert into dish_order(d_id,o_id,count_) values (2,1,1); insert into dish_order(d_id,o_id,count_) values (2,2,1); insert into dish_order(d_id,o_id,count_) values (2,4,1); insert into dish_order(d_id,o_id,count_) values (4,2,1); insert into dish_order(d_id,o_id,count_) values (4,5,1); insert into dish_order(d_id,o_id,count_) values (4,4,4); insert into dish_order(d_id,o_id,count_) values (5,3,2); insert into dish_order(d_id,o_id,count_) values (5,6,1); select * from dish_order;