drop table if exists t1; create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr)); select count(*) from t1; count(*) 0 select * from t1; nr b str select * from t1 limit 0; nr b str drop table t1;