I am new to MySQL, I try to use MySQL to store my stock data. I followed the answer by boe100 in reference: Database schema for organizing historical stock data I create my table as follows: mysql> describe StockDailyQuotations; Field Type Null Key Default Extra ts_code varchar(9) NO PRI NULL trade_date int(8) NO PRI NULL open decimal(6,2) NO NULL high