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

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 642 total)
1 2 3 4 5 6 … 41 42 43
  • Author
    Posts
  • May 12, 2005 at 10:20 am in reply to: Almost Cosmetic – ALTER TABLE bug #17669
    Shadow
    Member

    This may also be a W2K GUI related issue. Forum does not accept my screenshot saying too large (~27K:cool: 🙁

    May 9, 2005 at 8:38 am in reply to: delete n ammend data #17682
    Shadow
    Member

    If you want to replace more than one occurances of '-' character, then use REPLACE() function insted of INSERT().

    May 9, 2005 at 8:36 am in reply to: delete n ammend data #17681
    Shadow
    Member

    UPDATE my_table SET my_field=INSERT(my_field, (INSTR(my_field, '-'), 1,'');

    INSERT function will replace '-' character with '' (empty string) at its first occurance(INSTR locates the first occurance) in my_field.

    May 9, 2005 at 8:29 am in reply to: Problem with Personal Folders #17656
    Shadow
    Member

    Which version of SQLyog do you use? Contents of the personal folder can be deleted manually, it is located under SQLyog's installation folder.

    May 9, 2005 at 8:21 am in reply to: Almost Cosmetic – ALTER TABLE bug #17666
    Shadow
    Member

    I must confirm this GUI bug! The only catch is that before dropping the column, cursor must be located in the box containing the name of the field.

    May 6, 2005 at 9:28 am in reply to: Bug: 4.05 Copy result to clipboard #17636
    Shadow
    Member

    I use it frequently to get the correct SQL statement for exporting data from the server, then I copy that statement to a batch file… 🙄

    May 6, 2005 at 9:05 am in reply to: set focus on SQL window #17643
    Shadow
    Member

    Well, I think focus moves to result pane because the creators assumed that after executing a query, you would like to check its results.

    If you want to execute several queries in a row, then select them and press F5 or simply Shift+F5 in case all queries in SQL window need to get executed.

    May 6, 2005 at 9:00 am in reply to: Bug: 4.05 Copy result to clipboard #17634
    Shadow
    Member

    Great idea! 😀

    May 6, 2005 at 8:18 am in reply to: Bug: 4.05 Copy result to clipboard #17632
    Shadow
    Member

    And it might be a good idea to add GUI support for generally used separator characters such as n or rn. Some users may not know how to encode for example Windows style new line character…

    May 5, 2005 at 7:38 am in reply to: Feature Req : Character Sets and Collations #17638
    Shadow
    Member

    All of your requests are on the TODO list 😀

    May 3, 2005 at 12:54 pm in reply to: Error Code: 1005 #17586
    Shadow
    Member

    Thanks! 😀 I have managed to get a development task once again, so I'll be using MySql and SQLyog rather frequently.

    May 3, 2005 at 12:48 pm in reply to: ssl support in sqlyog? future plans to integrate? #17565
    Shadow
    Member

    You need privileges to those columns of underlying tables only that are referred to by the view being created. As far as I'm concerned, create view and show view privileges are not table related either.

    May 3, 2005 at 12:08 pm in reply to: Error Code: 1005 #17584
    Shadow
    Member

    Exactly!

    May 3, 2005 at 12:05 pm in reply to: Importing users and privileges once again #17529
    Shadow
    Member

    MySql does not encrypt passwords, it merely creates a hash and stores that instead of password.

    May 3, 2005 at 11:46 am in reply to: Error Code: 1005 #17582
    Shadow
    Member

    The problem is related to the fact, that most my.cnf and my.ini files contain special rules for MySql's command line utilities – such as an increased max_allowed_packet setting.

    Charsets and collations are an issue with SQLyog, they are not really taken into consideration when an operation gets performed by SQLyog.

  • Author
    Posts
Viewing 15 posts - 61 through 75 (of 642 total)
1 2 3 4 5 6 … 41 42 43