1 echo Create table t1
(f1 varchar
(10), f2 int
, primary key
(f1
));
3 echo Create table t2
(f1 varchar
(10), f2 bigint
, foreign key
(f1
) references t1
(f1
));
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 echo insert into t1 values
(NULL
,3);
8 Statement execute failed with error
-22
9 echo insert into t1 values
('CSQL2',4);
10 Statement execute failed with error
-21
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
18 echo update t1
set f1
='CSQL1' where f1
='CSQL2';
19 Statement prepare failed with error
-21
20 echo select * from t1
;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
27 Statement Executed
: Rows Affected
= 1
28 Statement Executed
: Rows Affected
= 1
29 echo insert into t2 values
('CSQL3',30);
30 Statement execute failed with error
-35
31 echo select * from t2
;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
38 echo delete from t1 where f1
='CSQL1';
39 Statement execute failed with error
-36
40 echo select * from t1
;
41 ---------------------------------------------------------
43 ---------------------------------------------------------
47 echo select * from t2
;
48 ---------------------------------------------------------
50 ---------------------------------------------------------
54 <Table Information of all tables
>
56 <TableName
> t1
</TableName
>
58 <FieldName
> f1
</FieldName
>
61 <Primary
> 1 </Primary
>
63 <Default
> 0 </Default
>
64 <DefaultValue
> </DefaultValue
>
67 <FieldName
> f2
</FieldName
>
70 <Primary
> 0 </Primary
>
72 <Default
> 0 </Default
>
73 <DefaultValue
> </DefaultValue
>
77 <TableName
> t2
</TableName
>
79 <FieldName
> f1
</FieldName
>
82 <Primary
> 0 </Primary
>
84 <Default
> 0 </Default
>
85 <DefaultValue
> </DefaultValue
>
88 <FieldName
> f2
</FieldName
>
91 <Primary
> 0 </Primary
>
93 <Default
> 0 </Default
>
94 <DefaultValue
> </DefaultValue
>
97 </Table Information of all tables
>
98 <Index Information of all Indexs
>
99 <Index Name
> t1_idx1_Primary
</Index Name
>
100 <Index Type
> Hash Index
</Index Type
>
101 <Table Name
> t1
</Table Name
>
102 <Field Name
> f1
</Field Name
>
103 </Index Information of all Indexs
>