![(please configure the [header_logo] section in trac.ini)](/share/chrome/site/your_project_logo.png){kind=logo}
Changeset 20387 for lang/php/misc/Hermit/test/resource/test-mysql.sql.php
- Timestamp:
- 10/01/08 21:02:13 (3 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
lang/php/misc/Hermit/test/resource/test-mysql.sql.php
r20314 r20387 29 29 $stmt = $pdo->query($sql); 30 30 $stmt->closeCursor(); 31 unset($stmt); 32 31 33 32 34 $sql = <<<__SQL__ … … 35 37 $stmt = $pdo->query($sql); 36 38 $stmt->closeCursor(); 39 unset($stmt); 40 37 41 $sql = <<<__SQL__ 38 42 INSERT INTO EMP VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30,'2000-01-01 00:00:00.0'); … … 40 44 $stmt = $pdo->query($sql); 41 45 $stmt->closeCursor(); 46 unset($stmt); 47 42 48 $sql = <<<__SQL__ 43 49 INSERT INTO EMP VALUES(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30,'2000-01-01 00:00:00.0'); … … 45 51 $stmt = $pdo->query($sql); 46 52 $stmt->closeCursor(); 53 unset($stmt); 54 47 55 $sql = <<<__SQL__ 48 56 INSERT INTO EMP VALUES(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20,'2000-01-01 00:00:00.0'); … … 50 58 $stmt = $pdo->query($sql); 51 59 $stmt->closeCursor(); 60 unset($stmt); 61 52 62 $sql = <<<__SQL__ 53 63 INSERT INTO EMP VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30,'2000-01-01 00:00:00.0'); … … 55 65 $stmt = $pdo->query($sql); 56 66 $stmt->closeCursor(); 67 unset($stmt); 68 57 69 $sql = <<<__SQL__ 58 70 INSERT INTO EMP VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30,'2000-01-01 00:00:00.0'); … … 60 72 $stmt = $pdo->query($sql); 61 73 $stmt->closeCursor(); 74 unset($stmt); 75 62 76 $sql = <<<__SQL__ 63 77 INSERT INTO EMP VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10,'2000-01-01 00:00:00.0'); … … 65 79 $stmt = $pdo->query($sql); 66 80 $stmt->closeCursor(); 81 unset($stmt); 82 67 83 $sql = <<<__SQL__ 68 84 INSERT INTO EMP VALUES(7788,'SCOTT','ANALYST',7566,'1982-12-09',3000.0,NULL,20,'2005-01-18 13:09:32.213'); … … 70 86 $stmt = $pdo->query($sql); 71 87 $stmt->closeCursor(); 88 unset($stmt); 89 72 90 $sql = <<<__SQL__ 73 91 INSERT INTO EMP VALUES(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10,'2000-01-01 00:00:00.0'); … … 75 93 $stmt = $pdo->query($sql); 76 94 $stmt->closeCursor(); 95 unset($stmt); 96 77 97 $sql = <<<__SQL__ 78 98 INSERT INTO EMP VALUES(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30,'2000-01-01 00:00:00.0'); … … 80 100 $stmt = $pdo->query($sql); 81 101 $stmt->closeCursor(); 102 unset($stmt); 103 82 104 $sql = <<<__SQL__ 83 105 INSERT INTO EMP VALUES(7876,'ADAMS','CLERK',7788,'1983-01-12',1100,NULL,20,'2000-01-01 00:00:00.0'); … … 85 107 $stmt = $pdo->query($sql); 86 108 $stmt->closeCursor(); 109 unset($stmt); 110 87 111 $sql = <<<__SQL__ 88 112 INSERT INTO EMP VALUES(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30,'2000-01-01 00:00:00.0'); … … 90 114 $stmt = $pdo->query($sql); 91 115 $stmt->closeCursor(); 116 unset($stmt); 117 92 118 $sql = <<<__SQL__ 93 119 INSERT INTO EMP VALUES(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20,'2000-01-01 00:00:00.0'); … … 95 121 $stmt = $pdo->query($sql); 96 122 $stmt->closeCursor(); 123 unset($stmt); 124 97 125 $sql = <<<__SQL__ 98 126 INSERT INTO EMP VALUES(7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10,'2000-01-01 00:00:00.0'); … … 100 128 $stmt = $pdo->query($sql); 101 129 $stmt->closeCursor(); 130 unset($stmt); 131 102 132 103 133 $sql = <<<__SQL__ … … 112 142 $stmt = $pdo->query($sql); 113 143 $stmt->closeCursor(); 144 unset($stmt); 145 114 146 115 147 $sql = <<<__SQL__ … … 118 150 $stmt = $pdo->query($sql); 119 151 $stmt->closeCursor(); 152 unset($stmt); 153 120 154 $sql = <<<__SQL__ 121 155 INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS', 0, 1); … … 123 157 $stmt = $pdo->query($sql); 124 158 $stmt->closeCursor(); 159 unset($stmt); 160 125 161 $sql = <<<__SQL__ 126 162 INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO', 0, 1); … … 128 164 $stmt = $pdo->query($sql); 129 165 $stmt->closeCursor(); 166 unset($stmt); 167 130 168 $sql = <<<__SQL__ 131 169 INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON', 0, 1); … … 133 171 $stmt = $pdo->query($sql); 134 172 $stmt->closeCursor(); 173 unset($stmt); 174 135 175 136 176 $pdo->commit();
