insert into tide_data( adate, udate, area_id, tide_date, tide_date_week, qreki_date, moon_age, sun_rise_time, sun_set_time, moon_rise_time, moon_set_time, high_tide_time1, high_tide_time2, low_tide_time1, low_tide_time2, high_tide_num1, high_tide_num2, low_tide_num1, low_tide_num2, siohigari_time1_from, siohigari_time1_to, siohigari_time2_from, siohigari_time2_to, agesio_time1_from, agesio_time1_to, agesio_time2_from, agesio_time2_to, sagesio_time1_from, sagesio_time1_to, sagesio_time2_from, sagesio_time2_to )values( sysdate(), sysdate(), '268', '2012-02-1', '3', '2012-1-10', 8.8, '2012-02-1 6:36:00', '2012-02-1 16:31:00', '2012-02-1 10:33:00', '2012-02-1 0:44:00', '2012-02-01 07:36', NULL, '2012-02-01 00:23', '2012-02-01 16:04', 123, NULL, 75, 49, NULL, NULL, NULL, NULL, '2012-02-01 02:32', '2012-02-01 05:26', NULL, NULL, '2012-02-01 10:08', '2012-02-01 13:31', NULL, NULL ) Duplicate entry '2012-02-01-268' for key 'tide_date'