1create database if not exists testdb;

1desc database testdb;

1use testdb;

1drop database if exists testdb;

1create table if not exists t (id bigint, value string);

1desc formatted t;

1show tables;

1OK
2t

1drop table if exists t;

1insert into table t select 1, 'value-1';

1select * from t limit 10;

1select value, count(id) from t group by value;