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 0 reply threads
  • Author
    Posts
    • 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 0 reply threads
  • You must be logged in to reply to this topic.