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

Spaces in the column names are not supported

forums forums SQLyog SQLyog: Bugs / Feature Requests Spaces in the column names are not supported

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #7768
      edmund
      Member

      I've tried a number of operations (import from ODBC and from a flat file) and it fails because the load command that is generated does not handle spaces in the column names.

    • #13933
      CalEvans
      Member

      I think this is more of a mysql issue than a SQLyog issue. mysql supports spaces in the column names but the names must be surrounded by back-ticks. (`). I know this is true in all other cases but I don't import from ODBC or flat files much so I don't have anything to test with.

      create a test file with back-ticks around the file names and try to import it. See if that doesn't solve the problem. (Let us know here either way.)

      =C=

      p..s (IMHO)Spaces in field names and table names are bad. Mkayyyyyy.(/IMHO) 😀

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