Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Importexternaldata: Double-field-errror

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Importexternaldata: Double-field-errror

Tagged: ,

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 29, 2014 at 7:50 pm #35105
      peterlaursen
      Participant

      We will check after the weekend.

       

      To make it easier for us can you provide CREATE statement for the affected table (execute “SHOW CREATE TABLE tablename;” It may matter if there is PRIMARY KEY or UNIQUE KEY on the column.  You should never have on FLOAT and DOUBLE columns in MySQL – please refer http://faq.webyog.com/content/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

    • December 1, 2014 at 1:46 pm #35106
      kheine
      Member

      Thanks for your help.  😀

       

      In the SQLyog FAQ there is this hint:

       

      ‘When using Floating Point datatypes there should always be a PK based on non-floating column(s) and the PK-column(s) should be included in every SELECT generating a result set used for updating the table.’

       

      Taking the index-field into my SELECT, the incremental transfer works fine.

       

      Your SQLyog: an excellent tool !

       

      Best regards

      K.Heine

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.