MySQL Create Table SQL
Table Structure: okayapi_response：/tablelist/okayapi_response.html
-- MySQL Table okayapi_response
-- From: OkayAPI.com
CREATE TABLE `okayapi_response` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`method` varchar(10) NULL DEFAULT 'GET' COMMENT '方法',
`model` varchar(20) NULL COMMENT '表名，table是SQL关键词不能用',
`structure` varchar(100) NULL COMMENT '结构',
`detail` varchar(10000) NULL COMMENT '详细说明',
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
KEY `method` (`method`),
KEY `model` (`model`),
KEY `structure` (`structure`),
KEY `detail` (`detail`),
KEY `date` (`date`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'web开发-服务器响应表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| method | varchar(10) | GET | 是 | 方法 | GET | |
| model | varchar(20) | 否 | 表名，table是SQL关键词不能用 | |||
| structure | varchar(100) | 否 | 结构 | |||
| detail | varchar(10000) | 是 | 详细说明 | |||
| date | timestamp | CURRENT_TIMESTAMP | 是 | 创建日期 | CURRENT_TIMESTAMP |
