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

Table Data View

forums › forums › SQLyog › Using SQLyog › Table Data View

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • July 10, 2007 at 9:13 pm #10440
      Ryan Butler
      Member

      Is there a way in table data view to insert a new record above a first entry? For instance, you have four records, and before the first, I need to insert another record, how can this be accomplished?

      Thanks,

    • July 10, 2007 at 9:33 pm #24505
      peterlaursen
      Participant

      There is no way, and it is not an issue with SQLyog!

      SQLyog communicates with the MySQL server using SQL. SQL has no such option when inserting data, and SQL databases like MySQL do not recognize 'above' or 'below'. There is no GUI view at all recognized by the server and the server simply has no clue about what a client does with the data after data has been sent from the server to the client!

      To sort data in a specific order You will have to ORDER BY …

      1)by writing a query

      2)or by clicking the small square above every column

      3)or by using the Query Builder (from 6.0)

      Basically a database is not a spreadsheet!

    • July 11, 2007 at 12:56 pm #24506
      Ryan Butler
      Member

      Ok, I thought SQL Server had a way to do that. I know it's not an issue with SQL yog.

      Thanks for the reply,

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.