阅读背景:

错误:列mysql rails超出范围值

来源:互联网 

I have sql table:

我有sql表:

-- Table structure for rb_amazon_daily
-- ----------------------------
DROP TABLE IF EXISTS `rb_amazon_daily`;
CREATE TABLE `rb_amazon_daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `book_title` varchar(255) DEFAULT NULL,
  `marketplace` varchar(255) DEFAULT NULL,
  `amazon_kdp_avg_list_price` decimal(12,10) DEFAULT NULL,
  `amazon_kdp_royalty_type` varchar(255) DEFAULT NULL,
  `amazon_kdp_revenue_in_usd` decimal(13,13) DEFAULT NULL,
  `amazon_kdp_royalty_in_usd` decimal(13,13) DEFAULT NULL,
  `amazon_kdp_paid_downloads` int(11) DEFAULT NULL,
  `amazon_kdp_free_downloads` int(11) DEFAULT NULL,
  `amazon_ku_pages_read` int(11) DEFAULT NULL,
  `amazon_ku_revenue_in_usd` decimal(12,10) DEFAULT NULL,
  `create_space_revenue_in_usd` decimal(12,10) DEFAULT NULL,
  `create_space_royalty_in_usd` decimal(12,10) DEFAULT NULL,
  `create_space_paperbacks_sold` int(11) DEFAULT NULL,
  `daily_total_revenue` decimal(12,10) DEFAULT NULL,
  `daily_total_royalty` decimal(12,10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=301 DEFAULT CHARSET=latin1;
-- Table structur



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: