MySQL Create Table SQL
Table Structure: okayapi_rank：/tablelist/okayapi_rank.html
-- MySQL Table okayapi_rank
-- From: OkayAPI.com
CREATE TABLE `okayapi_rank` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`list_goods` varchar(50) NULL COMMENT '产品名',
`list_sales` int(10) NULL COMMENT '产品销售量',
`list_rank` int(10) NULL COMMENT '产品排名',
`list_hot` int(10) NULL COMMENT '产品热度，百分制100表示非常热',
KEY `list_goods` (`list_goods`),
KEY `list_sales` (`list_sales`),
KEY `list_rank` (`list_rank`),
KEY `list_hot` (`list_hot`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '排名';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| list_goods | varchar(50) | 是 | 产品名 | |||
| list_sales | int(10) | 是 | 产品销售量 | |||
| list_rank | int(10) | 是 | 产品排名 | |||
| list_hot | int(10) | 是 | 产品热度，百分制100表示非常热 |
