ABCDEFGHIJKLM是字段名,
求(A、B、C),(D、E、F),(G、H、I、J、K、L、M)三组字段名中各取一个,查询所有的组合
求(A、B、C),(D、E、F),(G、H、I、J、K、L、M)三组字段名中各取一个,查询所有的组合
解决方案 »
- 关于mysql分区partition
- mysql 不支持中文字符查询
- 进来看看,关于周和月查询sql的写法
- mysql插入汉字
- Sqlyog连接Mysql时错误:2004,can't create tcp/ip sokect (10050).请问怎么解决?
- 求助mysql-5.1.6-alpha-win32简化安装的问题
- mysql的表里有没有一个相当于foxpro中记录号的东西?
- MySQL数据表中记录为何不能自动排序???
- Mybatis用hashMap作为参数类型问题
- 存储过程Insert语句怎样处理接受到的Varchar类型值
- 如何把A表中的B表中不存在的数据插入到B表中,谢谢
- 有大神吗
select *
from
(select a from t
union all
select b from t
union all
select c from t) t1,
(select d from t
union all
select e from t
union all
select f from t) t2,
(select g from t
union all
select h from t
union all
select i from t
union all
select j from t
union all
select k from t
union all
select l from t
union all
select m from t) t3,
from
(select D1 from feature
union all
select J1 from feature
union all
select Z1 from feature
union all
select L1 from feature
union all
select Y1 from feature) t1,
(select D2 from feature
union all
select J2 from feature
union all
select Z2 from feature
union all
select L2 from feature
union all
select Y2 from feature) t2,
(select D3 from feature
union all
select J3 from feature
union all
select Z3 from feature
union all
select L3 from feature
union all
select Y3 from feature) t3,
from
(select concat(D1,J1,Z1,L1,Y1)
from feature) as a,
(select concat(D2,J2,Z2,L2,Y2)
from feature) as b,
(select concat(D3,J3,Z3,L3,Y3)
from feature)as c