ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
```[sql] /* Navicat MySQL Data Transfer Source Server : 基金数据包年 Source Server Version : 50648 Source Host : 139.196.50.92:3306 Source Database : fund Target Server Type : MYSQL Target Server Version : 50648 File Encoding : 65001 Date: 2020-07-20 00:39:17 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fund_grow -- ---------------------------- DROP TABLE IF EXISTS `fund_grow`; CREATE TABLE `fund_grow` ( `fundCode` char(8) NOT NULL COMMENT '基金代码', `lastWeek` float DEFAULT NULL COMMENT '周增长率', `lastWeekAvg` float DEFAULT NULL COMMENT '周同类平均涨跌率', `lastWeekRank` int(11) DEFAULT NULL COMMENT '周同类排名', `lastWeekCount` int(11) DEFAULT NULL COMMENT '周同类总数', `lastMonth` float DEFAULT NULL COMMENT '近一月涨跌幅', `lastMonthAvg` float DEFAULT NULL COMMENT '近一月同类涨跌幅', `lastMonthRank` int(11) DEFAULT NULL COMMENT '近一月同类排名', `lastMonthCount` int(11) DEFAULT NULL COMMENT '近一月同类总量', `lastQuarter` float DEFAULT NULL COMMENT '近一季涨跌幅', `lastQuarterAvg` float DEFAULT NULL, `lastQuarterRank` int(11) DEFAULT NULL, `lastQuarterCount` int(11) DEFAULT NULL, `lastHalfYear` float DEFAULT NULL COMMENT '近半年涨跌幅', `lastHalfYearAvg` float DEFAULT NULL, `lastHalfYearRank` int(11) DEFAULT NULL, `lastHalfYearCount` int(11) DEFAULT NULL, `lastYear` float DEFAULT NULL COMMENT '近一年涨跌幅', `lastYearAvg` float DEFAULT NULL, `lastYearRank` int(11) DEFAULT NULL, `lastYearCount` int(11) DEFAULT NULL, `twoYear` float DEFAULT NULL, `twoYearAvg` float DEFAULT NULL, `twoYearRank` int(11) DEFAULT NULL, `twoYearCount` int(11) DEFAULT NULL, `thirdYear` float DEFAULT NULL, `thirdYearAvg` float DEFAULT NULL, `thirdYearRank` int(11) DEFAULT NULL, `thirdYearCount` int(11) DEFAULT NULL, `fiveYear` float DEFAULT NULL, `fiveYearAvg` float DEFAULT NULL, `fiveYearRank` int(11) DEFAULT NULL, `fiveYearCount` int(11) DEFAULT NULL, `nowYear` float DEFAULT NULL COMMENT '今年以来涨跌幅', , `nowYearAvg` float DEFAULT NULL, `nowYearRank` int(11) DEFAULT NULL, `nowYearCount` int(11) DEFAULT NULL, `allYear` float DEFAULT NULL COMMENT '成立以来涨跌幅', `allYearAvg` float DEFAULT NULL, `allYearRank` int(11) DEFAULT NULL, `allYearCount` int(11) DEFAULT NULL, PRIMARY KEY (`fundCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ```