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

Insert New Field

forums › forums › SQLyog › SQLyog BETA Discussions › Insert New Field

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • October 10, 2007 at 7:23 pm #10583
      MRC
      Member

      It doen't appear you can alter an existing table by inserting a new field at the top of the list using SQLyog Community 6.1 Beta. You can insert a field anywhere else in the list and at the end but not at the top. After you insert the new field and click the Alter button you get an hourglass and that's all. It works fine in Community 6.0.7.

      To duplicate, create a table with a few fields in it, save it and dismiss the setup window. Select the new table, press F6, insert a new field at the top of the list, and press Alter.

      I am running SQLyog Community 6.1 Beta, MYSql 5.0.45, XP Pro.

    • October 10, 2007 at 8:03 pm #25111
      peterlaursen
      Participant

      That was reported internally a few days ago and fixed in beta3 that was released today.

      It also works for me now.

      Can you confirm the fix with beta3?

    • October 10, 2007 at 8:15 pm #25112
      peterlaursen
      Participant

      My mistake. Not yet fixed in beta3! 😡

    • October 10, 2007 at 9:02 pm #25113
      peterlaursen
      Participant

      It seems to be too late!

      It IS fixed for me with beta3 – and it also should be! Please try!

    • October 10, 2007 at 11:12 pm #25114
      MRC
      Member

      It works.

    • May 18, 2009 at 6:16 am #25115
      jeeva
      Member

      Hi All,

      I am new in MySQL Database. Can anybody give sample stored procedure for Insert Query with “Exception handling”.

      Please…

      by

      JEEVA

    • May 18, 2009 at 7:57 am #25116
      peterlaursen
      Participant

      You use DECLARE HANDLER syntax.

      Examples in MySQL documentation here: http://dev.mysql.com/doc/refman/5.0/en/declare-handler.html

      (and btw: I think you should start your questions in a new thread and not use the threads of other people)

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