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
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