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

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • March 10, 2015 at 12:13 pm in reply to: Merge Data Question #35230
    gaia
    Member

    Almost there.

     

    Since MySQL expects DATE and DATETIME literal values to be single-quoted as strings like ‘2001-01-01 00:00:00’, does SQLyog handle that or does the data source need to have the single quotes around the date field?

     

    I can’t get the where clause to parse. I assume that the name can’t be the file name, but it has to be the data source name SQLyog creates (and it says do not change the datasource name) `sqlyog_temp_1425989092`. Is this correct?

     

    There is no = or [] in the string I need to enter. its just `sqlyog_temp_1425989092`.`code`=`table_a`.`code`. (The table name has no spaces or uppercase) Is this correct?

     

    I tried a few options but it didnt parse.

     

    thanks!

    March 9, 2015 at 10:59 am in reply to: Merge Data Question #35228
    gaia
    Member

    Please reply to one question: can it happen that the .csv has a row (as identified by `code`) that does not exist in the database? If fhis is possible, what should then happen? Should such rows be INSERTED to the database or should they be ignored? 

     

    All codes in the csv exist in the DB. As a precaution, they should be ignored.

     

    Thank you for noting that I failed to inform this.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)