В результате заполнился столбец time, остальные - "0", и постоянная ошибка - 1062. Вот лог ошибок с корня квика:
10/01/20 11:48:43.807 [TID=4184] ClearTable: "stocks" henv = 00000000003B7210, hdbc = 00000000003B04F0, insert_into_table = 00000000003B5070, update_table = 00000000003B5640, delete_from_table = 00000000003B9110, hstmt = 00000000003B96E0, SQL statement = "DELETE FROM sbrf.stocks" 10/01/20 11:48:43.809 [TID=4184] Clear table 1 "stocks" 10/01/20 11:48:43.809 [TID=4184] Start ODBC export to table "stocks" 10/01/20 11:48:43.809 [TID=4184] After ExistData, table = stocks, ExistNewDataForExport = FALSE SQL statement = "is absent" 10/01/20 11:48:43.810 [TID=4184] Poke Data, table = stocks, henv = 00000000003B7210, hdbc = 00000000003B04F0, insert_into_table = 00000000003B5070, update_table = 00000000003B5640, delete_from_table = 00000000003B9110, hstmt = 00000000003B5070, SQL statement = "INS ERT IN TO sbrf.stocks (time) VALUES ('19:05:00')" 10/01/20 11:48:43.814 [TID=4184] Duration: 15 10/01/20 11:48:43.814 [TID=4184] After ExistData, table = stocks, ExistNewDataForExport = FALSE SQL statement = "is absent" 10/01/20 11:48:43.814 [TID=4184] Poke Data, table = stocks, henv = 00000000003B7210, hdbc = 00000000003B04F0, insert_into_table = 00000000003B5070, update_table = 00000000003B5640, delete_from_table = 00000000003B9110, hstmt = 00000000003B5070, SQL statement = "INS ERT IN TO sbrf.stocks (time) VALUES ('19:05:00')" 10/01/20 11:48:43.815 [TID=4184] Duration: 0 10/01/20 11:48:43.815 [TID=4184] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.21]Duplicate entry '19:05:00' for key 'stocks.PRIMARY' SQLSTATE=23000 Код ошибки=1062
Поиск костылей в инете ни к чему не привел.
Сразу скажу, что я не являюсь аховым юзером MySQL - только начал осваивать.
Подскажите решение