create table asd(name int check(name=1), age int(1)primary key);
create table qwe(mane int, gae int(1) references asd(age));
create table pow(aa int);
insert into asd values(1,2);
insert into qwe values(1,2);
insert into pow values(1);
select name, age
from asd
inner join qwe on
asd.name=qwe.mane
right join pow
on pow.aa=asd.name;
desc asd;
desc qwe;
alter table asd drop constraint name;
show create table asd;