UPDATE tablea INNER JOIN tableb ON tablea.fielda=tableb.fieldb SET tablea.id=tableb.hid;
create table tb_4( id int primary key auto_increment,
type varchar(40),
foreign key type peferences tb_3 indentity
);
type varchar(40),
foreign key type peferences tb_3 indentity
);
2015-07-24
create table tb_3( id int unsigned primary key auto_increment,
username varchar(20) not null,
mobilephone varchar(20) unique key not null,
identity varchar(40) not null
);
username varchar(20) not null,
mobilephone varchar(20) unique key not null,
identity varchar(40) not null
);
2015-07-24