MySQL创建

create database asd;

use database a;

create table `a`(

`id` varchar(10),

`surname` varchar(10),

`name` varchar(10),

`age` int(10),

`sex`varchar(10),

`money`int(10));

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('01','zhang','san','20','male','10000');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('02','li','si','22','female','8000');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('03','wang','wu','21','female','12000');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('04','zhao','liu','19','female','9000');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('05','sun','qi','20','male','8800');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('06','zhou','ba','18','female','9500');

insert into `a` (`id`,`surname`,`name`,`age`,`sex`,`money`) values('07','wu','jiu','22','male','15000');

表b

create table `b`(

`id` varchar(10),

`username`varchar(10),

`age` int(10),

`sex`varchar(10),

`money`int(10));