insert into useful
select * from record
where name in (select name from record where address='10.20.126.65' group by name,admin,sex)
and admin in (select admin from record where address='10.20.126.65' group by name,admin,sex)
and sex in (select sex from record where address='10.20.126.65' group by name,admin,sex);
select * from record
where name in (select name from record where address='10.20.126.65' group by name,admin,sex)
and admin in (select admin from record where address='10.20.126.65' group by name,admin,sex)
and sex in (select sex from record where address='10.20.126.65' group by name,admin,sex);
解决方案 »
- MySQL5.0.15
- mysql查询乱码的记录
- mysql没有备份,数据被删掉,怎么找回以前数据
- postgreSQL 转 mysql
- 太多的Record lockhea no 87 PHYSICAL RECORD:n_fields 2;compact format
- 请教一个读取日期的问题
- sql时间查询语句怎么弄?
- MySQL Query Browser 1.2.4beta 不能输入中文语句(如图)
- in MYSQL is there similar sentence like SQL?
- mysqldump导出的insert语句过长
- 触发器中动态列名的问题!!
- 求一sql语句(mysql)
select * from record
where name+admin+sex in (select name+admin+sex from record where address='10.20.126.65' group by name,admin,sex)