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

Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • March 24, 2003 at 4:08 pm in reply to: Manage Relationships #13949
    Medozas
    Member

    Yup YEZ has it… Do exactly he says… You know, to help you we got to know, what your problem is… But just if you are a newbie: You need mysql 4.x to manage foreign keys, anything 3.x will not work…

    besides that, as in your message you have to change your table type to InnoDB, just do that with a right click on your table, then “Change table type to” –> “InnoDB”

    After that, check that you have indexes on the columns you wish to put in relationship.

    there are more hints and tricks to watch out for (unique, not null, etc… ) but just give us the SQL-Script, then we'll tell you…

    greetz

    March 24, 2003 at 3:59 pm in reply to: Group By problem #13959
    Medozas
    Member

    Actually maybe just giving a hint: But did you already try

    Quote:
    SELECT count(lcase(email)) as cnt,lcase(email) FROM `np_bieter`where email not null GROUP BY email

    WITHOUT HAVING!!

    give me create-table script so i can experiment, and ill help… or if it works… great! 😕

    March 21, 2003 at 2:08 pm in reply to: Manage Relationships #13945
    Medozas
    Member

    Sure, here I am… Had problems myself too, but whats your problem…. show me in sql your create table scripts and what kind of relationship you need…

    March 20, 2003 at 10:09 pm in reply to: How about Graphical Designer and MS-ACCESS Import? #13940
    Medozas
    Member

    If i could help in development…. just pass by! [email protected] 🙄

    March 20, 2003 at 4:42 pm in reply to: How about Graphical Designer and MS-ACCESS Import? #13938
    Medozas
    Member

    sorry… and primary keys?

    March 20, 2003 at 4:41 pm in reply to: How about Graphical Designer and MS-ACCESS Import? #13937
    Medozas
    Member

    I know, I get Table and Data….. but what about indexes and foreign keys?

    March 20, 2003 at 2:43 pm in reply to: GPL #13854
    Medozas
    Member

    BLOB: But how about WMF, icons, Rich Text or HTML? Like EMS?

    I know it has full support 🙂

    Thats why i said

    Quote:
    SQLyog is in my oppinion the best free mysql-frontend availiable.

    I hope you can keep up! 🙂

    If you might need any development help, and are interested, tell me… I'll be happy to support 🙂

    If it might help: VC++ 6, VB6, COM, FoxPro, Delphi, a. o.

    mailto:[email protected]

    Medozas

    March 19, 2003 at 4:23 pm in reply to: GPL #13852
    Medozas
    Member

    Well, actually I really respect what you do.. Really!

    SQLyog is in my oppinion the best free mysql-frontend availiable.

    It's a pity you really don't license it under GPL, because I could and would help in development of SQLyog. And nothing offensive, but: Do you really think you “alone” can keep up the speed of new development coming out now with MySQL (Foreign Keys, Stored Procedures, Views, Master-Slave-Replica, etc.)?

    Well, maybe you can, I don't know. Under GPL all kind of developers around the world would help create a better, faster, more stable product, for the whole mysql-community.

    As mentioned above, its right that as the development of mysql-front discontinued a lot of people were standing, and had to choose a new front-end…

    Just for file: I'm not explicitly asking for Releasing to GPL, i just want to show up a few positive things about that. As beeing a professional MySQL-User for also commercial use, i also have bought EMS MySQL Manager (www.ems-hitech.com) and MySQL Tools Developer (www.mysqltools.com), but thats only because I don't have any other possibility (BLOB, etc.). But indeed, as far as SQLyog goes, i use it (and love it). With GPL, i even would use my private ressources for development…

    Keep up the good work

    🙂

    Medozas

    March 19, 2003 at 4:00 pm in reply to: PhpMyadmin, need help :) #13934
    Medozas
    Member

    Hi there….

    Well I'm not that sure… I've installed MySQLAdmin just a few minutes ago, and i didn't have any problems except the No permission problem….

    try one thing:

    type

    QUOTE
    chmod 7777 {MAIN-PHPmyAdmin-PATH} -R -v

    (or the apropriate rights you wish to set, but I would set them later, when everything works)

    and

    QUOTE
    chown root.root  {MAIN-PHPmyAdmin-PATH} -R -v

    at the console.

    But as I said, I'm not sure… Try it… It couldn't happen more as you would have to redownload or reunzip…

    hope it helps

    🙂

    medozas

  • Author
    Posts
Viewing 9 posts - 1 through 9 (of 9 total)