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

Common Table Expressions

forums › forums › SQLyog › Using SQLyog › Common Table Expressions

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 13, 2011 at 5:40 pm #12450
      The New Guy
      Member

      I'm new to SQL so I don't know if I'm coding this wrong or what, but I haven't been able to create a CTE in SQLyog. Here is a very simplified version of my code:

      with CTETest as

      Select

      client_id

      , Client_Name

      , relation_type_desc

      , count(*) RelationTypeCount

      From consumer

      Group by relation_type_desc,client_id

      Am I doing something wrong, or is this something that can not be done in SQLyog?

      Any help would be great!

    • September 13, 2011 at 7:36 pm #32656
      peterlaursen
      Participant

      CTE (Common Table Expressions – http://msdn.microsof…y/ms190766.aspx) are not supported in MySQL- It is a (Microsoft) SQL Server construction. So what problem you experience with SQLyog you would with any client for MySQL. It is the MySQL server that returns the syntax error.

      Refer MySQL manual for supported SQL syntax with MySQL: http://dev.mysql.com…sql-syntax.html

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