blob: 7947161163880d3adb7b68d077d5031d7305b184 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
create table t1 (a integer, b integer,c1 CHAR(10));
insert into t1 (a) values (1),(2);
truncate table t1;
select count(*) from t1;
count(*)
0
insert into t1 values(1,2,"test");
select count(*) from t1;
count(*)
1
delete from t1;
select * from t1;
a b c1
drop table t1;
select count(*) from t1;
Table 'test.t1' doesn't exist
|