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

Create View

forums › forums › SQLyog › Using SQLyog › Create View

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 5, 2005 at 8:00 pm #9389
      rqamar
      Member

      Hi all – I am trying to use View in MySQL. I just realised that views are only available in version 5.0 and above. Could someone please tell me what’s the alternate to using views in older mysql?

      Many Thanks

    • December 5, 2005 at 8:14 pm #19966
      peterlaursen
      Participant
      Quote:
      what’s the alternate to using views in older mysql?

      It depends on why you originally intended to use VIEWS.

      Also it depends on the MySQL version and the amount of data and the server resources available to you.

      With MySQL 4.1 you might be able to use subqueries to reach your objective. For instance you could use a subquery to create a (temporary) table. For instance CREATE … TABLE … SELECT … WHERE somevariable LIKE (SELECT ….. )

      With MySQL <= 4.0 I can only think of splitting your tables into smaller tables.

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