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