Row_count() is displayed as 0
Sample code :
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (id int primary key, data int);
insert into t1 values (1, 1), (2, 2), (3, 3);
select * from t1;
select row_count();
Result file:
drop table if exists t1;
create table t1 (id int primary key, data int);
insert into t1 values (1, 1), (2, 2), (3, 3);
select * from t1;
id data
1 1
2 2
3 3
select row_count();
row_count()
0