表数据量的增幅不大两种都行,表数据量的增幅较大,数据结构相对完整的优先选第二种:SELECT DepName FROM `t_department`
WHERE ID= (
SELECT ParentDep
FROM t_department WHERE ID= 2
)SELECT parDepartment.DepName FROM `t_department`
JOIN (SELECT * FROM t_department) as parDepartment ON t_department.parentGroupId = parDepartment.groupId
WHERE t_department.groupId =3
WHERE ID= (
SELECT ParentDep
FROM t_department WHERE ID= 2
)SELECT parDepartment.DepName FROM `t_department`
JOIN (SELECT * FROM t_department) as parDepartment ON t_department.parentGroupId = parDepartment.groupId
WHERE t_department.groupId =3
from tb
where id=(select ParentDep from tb where id=$id);
这种格式 mysql 提示错误
第一种方法 MYSQL提示 从 (
SELECT ParentDep
FROM t_department WHERE ID= 2
) 这里开始出错
from 表结构及数据 t
where ID=2
第一种方法 MYSQL提示 从 (
SELECT ParentDep
FROM t_department WHERE ID= 2
) 这里开始出错
把错误信息贴出来,大家好帮你分析呀!
WHERE ID in (
SELECT ParentDep
FROM t_department WHERE ID= 2
)