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?
| SitePoint Sponsor |
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!"
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 mathematicsHere 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.
Cool beans, thanks Sid.
--Odd
"We all live in a yellow subroutine."
"Some call it insanity; I call it inspiration!"
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/
Posting Permissions
Bookmarks