HOME > �ｿｽﾏ撰ｿｽ�ｿｽﾌ暦ｿｽ�ｿｽp
�ｿｽ�ｿｽ�ｿｽs�ｿｽﾂ具ｿｽ (2008/3/1) MySQL 5.0 / Windows XP
�ｿｽﾏ撰ｿｽ�ｿｽﾌ暦ｿｽ�ｿｽp
�ｿｽ�ｿｽ�ｿｽ@
set @�ｿｽﾏ撰ｿｽ�ｿｽ�ｿｽ:=�ｿｽﾏ撰ｿｽ�ｿｽl;
�ｿｽ�ｿｽ
set @dep:=1;
select * from employees where department=@dep;
select * from employees where department=@dep;
employees
| id | name | department |
|---|---|---|
| 1 | �ｿｽ�ｿｽ�ｿｽ�ｿｽ | 1 |
| 2 | �ｿｽR�ｿｽc | 2 |
| 3 | �ｿｽ�ｿｽ�ｿｽ | 3 |
| 4 | �ｿｽ�ｿｽ�ｿｽc | 1 |
| 5 | �ｿｽ�ｿｽ�ｿｽc | 2 |
| 6 | �ｿｽ�ｿｽ�ｿｽ{ | 5 |
�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽﾌペ�ｿｽ[�ｿｽW�ｿｽﾌト�ｿｽb�ｿｽv
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾌ趣ｿｽ�ｿｽﾈ鯉ｿｽ�ｿｽ�ｿｽ PREVIOUS
�ｿｽﾖ撰ｿｽ�ｿｽﾌ暦ｿｽ�ｿｽp NEXT
HOME > �ｿｽﾏ撰ｿｽ�ｿｽﾌ暦ｿｽ�ｿｽp