SQLize Online / PHPize Online  /  SQLtest Online

create table tbl_trainer( tr_id int primary key, tr_name varchar(10), tr_rank int, tr_grade decimal(6,4), tr_bdate date ); create table tbl_monster( mns_id int primary key, mns_name varchar(50), mns_power decimal(6,4), tr_id int ); insert into tbl_trainer (tr_name, tr_rank, tr_grade, tr_bdate) values ('Ash', 1, 88, '1998-10-23'), ('Isa', 2, 86, '2001-02-18'), ('Gary', 1, 90, '1994-09-15'); insert into tbl_monster (mns_name, mns_power, tr_id) values ('Pika', 89, 1), ('Bulba', 90, 1), ('Poka', 81, 1), ('Charman', 87, 3), ('Amanwo', 87, 3); select * from tbl_trainer; select * from tbl_monster;