MySQL Create Table SQL
Table Structure: okayapi_studyabc_articles：/tablelist/okayapi_studyabc_articles.html
-- MySQL Table okayapi_studyabc_articles
-- From: OkayAPI.com
CREATE TABLE `okayapi_studyabc_articles` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`chititle` varchar(255) NOT NULL COMMENT '',
`engtitle` varchar(255) NOT NULL COMMENT '',
`picuri` varchar(250) NOT NULL COMMENT '',
`artid` varchar(40) NOT NULL COMMENT '',
`idate` date NOT NULL COMMENT '',
KEY `chititle` (`chititle`),
KEY `engtitle` (`engtitle`),
KEY `picuri` (`picuri`),
KEY `artid` (`artid`),
KEY `idate` (`idate`),
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-5 of 5 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| chititle | varchar(255) | 否 | ||||
| engtitle | varchar(255) | 否 | Normal Index | |||
| picuri | varchar(250) | 否 | ||||
| artid | varchar(40) | 否 | ||||
| idate | date | 否 | Normal Index |
