select id,col1,col2 from table1 union all select id,col1,col2 from table2 union all select id,col1,col2 from table3 这个语句完全符合楼主的要求。首先这是个MYSQL语句 其次,其中有三个表,算是多表了。 再者,三个的结果进行了合并。
A库 user 字段 Id UserName PassWord state Role0 Role1 Role2 01 adns 1223330 yianb 1 2 3 02 ahhh 0099877 kjjhi 4 5 6A库 role 字段 Id Name TypeId Level Phyle Money .......... 1 huang ssxx lkjjk kkiuh limmnk 2 2iin kkjj lkkj llkjnn lljjh 3 kkun lkij sswd sdddd ssddd 4 kjjbb swwww lkjhh jkjhh lkihjn 5 kjjjkl kjhbb ljjans ljjhnb kjhgbn 6 aakl lkjnns lkjmj jjaass lkjnna A库 item 字段 Id RoleId con attr typeid num0 ......... 01 1 sk ss 90 0 02 2 ss as 90 8 03 3 jh as 80 9 04 4 sa sas 80 0 05 5 li ki 79 9 06 6 kk hg 80 0A库 skill 字段 Id RoleId SkillId Level Exp skilltime 01 1 wd 0 0 0 02 2 ku 0 1 0 03 3 oi 1 0 1 04 4 ks 1 1 1 05 5 ky 0 0 1 06 6 ku 1 0 0 b库 user 字段 Id UserName PassWord state Role0 Role1 Role2 01 adns 1223330 yianb 1 2 3 02 ahhh 0099877 kjjhi 4 5 6b库 role 字段 Id Name TypeId Level Phyle Money .......... 1 huang ssxx lkjjk kkiuh limmnk 2 2iin kkjj lkkj llkjnn lljjh 3 kkun lkij sswd sdddd ssddd 4 kjjbb swwww lkjhh jkjhh lkihjn 5 kjjjkl kjhbb ljjans ljjhnb kjhgbn 6 aakl lkjnns lkjmj jjaass lkjnna b库 item 字段 Id RoleId con attr typeid num0 ......... 01 1 sk ss 90 0 02 2 ss as 90 8 03 3 jh as 80 9 04 4 sa sas 80 0 05 5 li ki 79 9 06 6 kk hg 80 0b库 skill 字段 Id RoleId SkillId Level Exp skilltime 01 1 wd 0 0 0 02 2 ku 0 1 0 03 3 oi 1 0 1 04 4 ks 1 1 1 05 5 ky 0 0 1 06 6 ku 1 0 0 效果:A库 user 字段 Id UserName PassWord state Role0 Role1 Role2 01 adns 1223330 yianb 1 2 3 02 ahhh 0099877 kjjhi 4 5 6 03 adns_a 1223330 yianb 7 8 9 04 ahhh_a 0099877 kjjhi 10 11 12 A库 role 字段 Id Name TypeId Level Phyle Money .......... 1 huang ssxx lkjjk kkiuh limmnk 2 2iin kkjj lkkj llkjnn lljjh 3 kkun lkij sswd sdddd ssddd 4 kjjbb swwww lkjhh jkjhh lkihjn 5 kjjjkl kjhbb ljjans ljjhnb kjhgbn 6 aakl lkjnns lkjmj jjaass lkjnna 7 huang_a ssxx lkjjk kkiuh limmnk 8 2iin_a kkjj lkkj llkjnn lljjh 9 kkun_a lkij sswd sdddd ssddd 10 kjjbb_a swwww lkjhh jkjhh lkihjn 11 kjjjkl_a kjhbb ljjans ljjhnb kjhgbn 12 aakl_a lkjnns lkjmj jjaass lkjnna A库 item 字段 Id RoleId con attr typeid num0 ......... 01 1 sk ss 90 0 02 2 ss as 90 8 03 3 jh as 80 9 04 4 sa sas 80 0 05 5 li ki 79 9 06 6 kk hg 80 0 07 7 sk ss 90 0 08 8 ss as 90 8 09 9 jh as 80 9 10 10 sa sas 80 0 11 11 li ki 79 9 12 12 kk hg 80 0 A库 skill 字段 Id RoleId SkillId Level Exp skilltime 01 1 wd 0 0 0 02 2 ku 0 1 0 03 3 oi 1 0 1 04 4 ks 1 1 1 05 5 ky 0 0 1 06 6 ku 1 0 0 07 7 wd 0 0 0 08 8 ku 0 1 0 09 9 oi 1 0 1 10 10 ks 1 1 1 11 12 ky 0 0 1 12 12 ku 1 0 0
union all
select id,col1,col2 from table2
union all
select id,col1,col2 from table3
这个语句完全符合楼主的要求。首先这是个MYSQL语句
其次,其中有三个表,算是多表了。
再者,三个的结果进行了合并。
字段 Id UserName PassWord state Role0 Role1 Role2
01 adns 1223330 yianb 1 2 3
02 ahhh 0099877 kjjhi 4 5 6A库 role
字段 Id Name TypeId Level Phyle Money ..........
1 huang ssxx lkjjk kkiuh limmnk
2 2iin kkjj lkkj llkjnn lljjh
3 kkun lkij sswd sdddd ssddd
4 kjjbb swwww lkjhh jkjhh lkihjn
5 kjjjkl kjhbb ljjans ljjhnb kjhgbn
6 aakl lkjnns lkjmj jjaass lkjnna
A库 item
字段 Id RoleId con attr typeid num0 .........
01 1 sk ss 90 0
02 2 ss as 90 8
03 3 jh as 80 9
04 4 sa sas 80 0
05 5 li ki 79 9
06 6 kk hg 80 0A库 skill
字段 Id RoleId SkillId Level Exp skilltime
01 1 wd 0 0 0
02 2 ku 0 1 0
03 3 oi 1 0 1
04 4 ks 1 1 1
05 5 ky 0 0 1
06 6 ku 1 0 0
b库 user
字段 Id UserName PassWord state Role0 Role1 Role2
01 adns 1223330 yianb 1 2 3
02 ahhh 0099877 kjjhi 4 5 6b库 role
字段 Id Name TypeId Level Phyle Money ..........
1 huang ssxx lkjjk kkiuh limmnk
2 2iin kkjj lkkj llkjnn lljjh
3 kkun lkij sswd sdddd ssddd
4 kjjbb swwww lkjhh jkjhh lkihjn
5 kjjjkl kjhbb ljjans ljjhnb kjhgbn
6 aakl lkjnns lkjmj jjaass lkjnna
b库 item
字段 Id RoleId con attr typeid num0 .........
01 1 sk ss 90 0
02 2 ss as 90 8
03 3 jh as 80 9
04 4 sa sas 80 0
05 5 li ki 79 9
06 6 kk hg 80 0b库 skill
字段 Id RoleId SkillId Level Exp skilltime
01 1 wd 0 0 0
02 2 ku 0 1 0
03 3 oi 1 0 1
04 4 ks 1 1 1
05 5 ky 0 0 1
06 6 ku 1 0 0
效果:A库 user
字段 Id UserName PassWord state Role0 Role1 Role2
01 adns 1223330 yianb 1 2 3
02 ahhh 0099877 kjjhi 4 5 6
03 adns_a 1223330 yianb 7 8 9
04 ahhh_a 0099877 kjjhi 10 11 12
A库 role
字段 Id Name TypeId Level Phyle Money ..........
1 huang ssxx lkjjk kkiuh limmnk
2 2iin kkjj lkkj llkjnn lljjh
3 kkun lkij sswd sdddd ssddd
4 kjjbb swwww lkjhh jkjhh lkihjn
5 kjjjkl kjhbb ljjans ljjhnb kjhgbn
6 aakl lkjnns lkjmj jjaass lkjnna
7 huang_a ssxx lkjjk kkiuh limmnk
8 2iin_a kkjj lkkj llkjnn lljjh
9 kkun_a lkij sswd sdddd ssddd
10 kjjbb_a swwww lkjhh jkjhh lkihjn
11 kjjjkl_a kjhbb ljjans ljjhnb kjhgbn
12 aakl_a lkjnns lkjmj jjaass lkjnna A库 item
字段 Id RoleId con attr typeid num0 .........
01 1 sk ss 90 0
02 2 ss as 90 8
03 3 jh as 80 9
04 4 sa sas 80 0
05 5 li ki 79 9
06 6 kk hg 80 0
07 7 sk ss 90 0
08 8 ss as 90 8
09 9 jh as 80 9
10 10 sa sas 80 0
11 11 li ki 79 9
12 12 kk hg 80 0
A库 skill
字段 Id RoleId SkillId Level Exp skilltime
01 1 wd 0 0 0
02 2 ku 0 1 0
03 3 oi 1 0 1
04 4 ks 1 1 1
05 5 ky 0 0 1
06 6 ku 1 0 0
07 7 wd 0 0 0
08 8 ku 0 1 0
09 9 oi 1 0 1
10 10 ks 1 1 1
11 12 ky 0 0 1
12 12 ku 1 0 0
他们的数值必须为一样且不能重复请给与相应的思路和处理办法