2 Statement Executed
: Rows Affected
= 1
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 Statement Executed
: Rows Affected
= 1
12 ---------------------------------------------------------
13 emp.eno emp.ename emp.dno
14 ---------------------------------------------------------
21 ---------------------------------------------------------
22 dept.deptno dept.dname dept.lid
23 ---------------------------------------------------------
29 ---------------------------------------------------------
30 emp.eno emp.ename emp.dno dept.deptno dept.dname dept.lid
31 ---------------------------------------------------------
33 1 Nihar
10 40 Sales
102
35 1 Nihar
10 30 Store
104
37 2 Papu
20 40 Sales
102
39 2 Papu
20 30 Store
104
41 3 Sima
30 40 Sales
102
43 3 Sima
30 30 Store
104
45 4 Nama
40 40 Sales
102
47 4 Nama
40 30 Store
104
49 5 Pinu
50 40 Sales
102
51 5 Pinu
50 30 Store
104
53 echo select * from emp where emp.deptno
in (20,30,40);
54 Statement prepare failed with error
-19
55 echo select * from emp
,dept where emp.deptno
in (20,30,40);
56 Statement prepare failed with error
-19