【sequoiadb|巨杉数据库】创建数据库实例
用户可以使用CREATE TABLE <TABLE_NAME>(<COLUMN_NAME> <COLUMN_TYPE>) 语句创建数据表。
示例:
mysql> CREATE TABLE employees (
-> emp_no INT NOT NULL,
-> birth_date DATE NOT NULL,
-> first_name VARCHAR(14) NOT NULL,
-> last_name VARCHAR(16) NOT NULL,
-> gender ENUM ('M','F') NOT NULL,
-> hire_date DATE NOT NULL,
-> PRIMARY KEY (emp_no)
-> );
Query OK, 0 rows affected (0.59 sec)
mysql> show create table employees;
+-----------+--------------+
| Table | Create Table |
+-----------+--------------+
| employees | CREATE TABLE `employees` (
`emp_no` int(11) NOT NULL,
`birth_date` date NOT NULL,
`first_name` varchar(14) NOT NULL,
`last_name` varchar(16) NOT NULL,
`gender` enum('M','F') NOT NULL,
`hire_date` date NOT NULL,
PRIMARY KEY (`emp_no`)
) ENGINE=SEQUOIADB DEFAULT CHARSET=utf8 |
+-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)
官网链接:http://doc.sequoiadb.com/cn/sequoiadb-cat_id-1561382407-edition_id-500