oceanbase

1
drop table if exists t1,t2,t3;
2
select count(*);
3
count(*)
4
1
5
select count(*) from dual;
6
count(*)
7
1
8
create table t1 (libname varchar(21), city varchar(256), primary key (libname));
9
select count(*) from t1;
10
count(*)
11
0
12
insert into t1 values ('test1','city1'),('test2','city2');
13
insert into t1 values ('l', null);
14
replace into t1 values ('2', null);
15
replace into t1 values ('test3','city3'),('test4','city4');
16
select count(*) from t1;
17
count(*)
18
6
19
select count(city) from t1;
20
count(city)
21
4
22
select count(t1.*) from t1;
23
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use
24