SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot New Oddity's Avatar
    Join Date
    Jun 2001
    Location
    Georgia
    Posts
    102
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    GUI MySQL Client And another question...

    Is there a free MySQL GUI client out there? I'm very intrested...

    Also... Is there a way to increment an int in a table without having to do an update statement AND a select statement?
    Last edited by New Oddity; Jun 19, 2001 at 07:13.
    --Odd
    "We all live in a yellow subroutine."
    "Some call it insanity; I call it inspiration!"

  2. #2
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    www.phpwizard.net/phpMyAdmin/ is a GUI for MySQL that you can use from your web browser. However, over time I have reverted back to the command line. Its' just simplere and quicker for me.

    Suprisingly, the propeller heads at IBM who developed the SQL language in the 1970s had a basic grasp of mathematics Here is an example of incrementing an int column type:

    UPDATE TableName
    SET myInt = myInt + 1
    WHERE ...

    There are in fact mathematica functions that handle more complex tasks built into the langauge too.

  3. #3
    SitePoint Zealot New Oddity's Avatar
    Join Date
    Jun 2001
    Location
    Georgia
    Posts
    102
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cool beans, thanks Sid.
    --Odd
    "We all live in a yellow subroutine."
    "Some call it insanity; I call it inspiration!"

  4. #4
    Talk to the /dev/null Theiggsta's Avatar
    Join Date
    Mar 2001
    Location
    Tampa, FL
    Posts
    376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    check out mysqlfront, its a very very very good windows gui thats under heavy development and I myself love it. The website is at http://www.mysqlfront.de/
    Aaron "Theiggsta" Kalin
    Pixel Martini
    Ruby and Rails Developer


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •