Create and Manage a Table

Create a table. For example, execute the following SQL statement to create a table which is named student and consists of the id, name, age, and birthday fields:

create table student(
  id int(11) primary key,
  name varchar(10),
  age smallint,
  birthday DATE
  ) engine=stonedb;

info

The column-based storage engine is named after StoneDB in StoneDB-5.6, and is renamed to Tianmu in StoneDB-5.7 to distinguish from the database StoneDB.

Query the schema of a table. For example, execute the following SQL statement to query the schema of table student:

show create table student;

Drop a table. For example, execute the following SQL statement to drop table student:

drop table student;