K線資料庫表結構

標籤：default   資料庫表   4.6   val   exists   table   myisam   ima   efault   

 

---- 資料庫: `bittrex`---- ------------------------------------------------------------ 表的結構 `ltc`--DROP TABLE IF EXISTS `ltc`;CREATE TABLE IF NOT EXISTS `ltc` (  `id` int(6) NOT NULL AUTO_INCREMENT,  `timestamp` varchar(10) NOT NULL,  `datetime` datetime NOT NULL,  `open` float NOT NULL,  `close` float NOT NULL,  `high` float NOT NULL,  `low` float NOT NULL,  `volume` float NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `timestamp` (`timestamp`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1440 ;---- 轉存表中的資料 `ltc`--INSERT INTO `ltc` (`id`, `timestamp`, `datetime`, `open`, `close`, `high`, `low`, `volume`) VALUES(1, ‘1504231200‘, ‘2017-09-01 10:00:00‘, 0.0152578, 0.01535, 0.01535, 0.0151101, 7564.68),(2, ‘1504234800‘, ‘2017-09-01 11:00:00‘, 0.0153596, 0.015645, 0.0156665, 0.015305, 14360.2),(3, ‘1504238400‘, ‘2017-09-01 12:00:00‘, 0.015645, 0.01585, 0.01605, 0.01561, 20670.2);

 

K線資料庫表結構