OLD | NEW |
1 # 2001 September 15 | 1 # 2001 September 15 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 602 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
613 ALTER TABLE t15 ADD COLUMN c; | 613 ALTER TABLE t15 ADD COLUMN c; |
614 CREATE INDEX t15c ON t15(c); | 614 CREATE INDEX t15c ON t15(c); |
615 INSERT INTO t15(a,b) | 615 INSERT INTO t15(a,b) |
616 VALUES(5,'zyx'),(15,'wvu'),(25,'tsr'),(35,'qpo'); | 616 VALUES(5,'zyx'),(15,'wvu'),(25,'tsr'),(35,'qpo'); |
617 UPDATE t15 SET c=printf("y%d",a) WHERE c IS NULL; | 617 UPDATE t15 SET c=printf("y%d",a) WHERE c IS NULL; |
618 SELECT a,b,c,'|' FROM t15 ORDER BY a; | 618 SELECT a,b,c,'|' FROM t15 ORDER BY a; |
619 } {5 zyx y5 | 10 abc y10 | 15 wvu y15 | 20 def y20 | 25 tsr y25 | 30 ghi y30 | 3
5 qpo y35 |} | 619 } {5 zyx y5 | 10 abc y10 | 15 wvu y15 | 20 def y20 | 25 tsr y25 | 30 ghi y30 | 3
5 qpo y35 |} |
620 | 620 |
621 | 621 |
622 finish_test | 622 finish_test |
OLD | NEW |