RE: SELF JOIN implementing a logical tree on one table

[Knepley, Jim]

It's been my experience that adjacency lists like what you describe are
difficult to query. I have had success with nested sets to represent
that kind of hierarchical data.

More information at:
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html 


-Original Message-
From: Joe Mellon [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 12, 2004 4:38 AM
To: [EMAIL PROTECTED]
Subject: SELF JOIN implementing a logical tree on one table

Hi Mysqlers,
 
I have a table which implements a tree-like heirarchy:
In the example below a geographical heirarchy.
 
I would like to be able to pick a node in the tree and Get everything
logically below that node in the heirarchy:
(A self join?)
 
#
# Table structure for `tree`
#
 
CREATE TABLE `tree` (
  `name` varchar(40) NOT NULL default '',
  `parentname` varchar(40) NOT NULL default ''
) TYPE=MyISAM;
 
#
# Data for Table `tree`
#
 
INSERT INTO `tree` VALUES ('USA', ''); INSERT INTO `tree` VALUES
('CA', 'USA'); INSERT INTO `tree` VALUES ('AZ', 'USA'); INSERT INTO
`tree` VALUES ('Orange', 'CA'); INSERT INTO `tree` VALUES ('Red', 'CA');
INSERT INTO `tree` VALUES ('Blue', 'CA'); INSERT INTO `tree` VALUES
('Apache', 'AZ'); INSERT INTO `tree` VALUES ('Navajo', 'AZ'); INSERT
INTO `tree` VALUES ('Mohawk', 'AZ'); INSERT INTO `tree` VALUES
('Monument', 'Apache'); INSERT INTO `tree` VALUES ('Statue', 'Apache');
 
 
I want to get e.g. all the locations in AZ.
 
SELECT t1.name, t1.parentname
FROM `tree` AS t1
  LEFT JOIN tree as t2 
ON t1.parentname=t2.name
WHERE t2.name='AZ';
 
Gets me
Apache  AZ
Navajo  AZ
Mohawk  AZ
 
But not the nodes with names Monument and Statue
 
SELECT t1.name, t1.parentname
FROM `tree` AS t1
  LEFT JOIN tree as t2 
ON t1.parentname=t2.name
  LEFT JOIN tree as t3 
ON t2.parentname=t3.name
WHERE t3.name='AZ';
 
Gets me 
MonumentApache
Statue  Apache
 
But not the nodes with names Apache, Navajo, Mohawk
 
Can anyone tell me the correct syntax to pick a node in the tree and get
everything logically below that node in the heirarchy?
 
   
Thanks
Joe Mellon,
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Size v Speed

[Knepley, Jim]

I can't really speak to OLEDB optimization, but I can speak to changing
over to PHP.

The MySQL database connector in PHP is pretty good from a performance
standpoint, and PHP itself is blazing fast in my experience. I've seen
massive performance gains in PERL by creating an abstraction that
PREPAREd repetitive queries, but the big shortcoming in PHP is that it
doesn't actually support the ability to PREPARE queries (though the PEAR
DB module will emulate it).

There may be other good reasons to use PHP, but database performance
probably isn't chief among them.

Somewhat unrealted, are you sure it's the network link that's the
bottleneck?




From: J.R. Bullington [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 12, 2004 11:28 AM
To: mysql
Subject: Size v Speed



Afternoon all, 
This is my first post and I have a quick question for you MySQL
experts out there. I am running a Red Hat 9 Linux box (2GHz, 1GB of RAM)
specifically designed for running a MySQL database. This database is
already over 3GB in size with over 120M records in 1 table (with 5
tables at the moment, averaging 50K records per table) and is going to
grow exponentially over the next few months. 

The issue that I am having is that the MyODBC connection that I
am using with my ASP system is starting to really slow down to the point
of having to limit my connections. I cannot get My OLEDB connections to
work at all and I am going to transfer this system to ASP.NET using
VB.NET, however if anyone could help now I would greatly appreciate it.

Here's the connection string at the moment: 
conn.Open DRIVER={MySQL ODBC 3.51
Driver};SERVER=*;DATABASE=*;USER=*;PASSWORD=*;OPTION=163
87; 
In the /etc/my.cnf file I have: 
(See Attached) 

I've tried using different connection options, including FORWARD-ONLY
CURSOR. I have already used MYISAMPACK to decrease my size, as well as
PROCEDURE ANALYSE() for optimizing the tables. We won't be pulling more
than a few thousand records per transaction, but multiple transactions.
With this info, here are the questions:

Is there anything that I can do to speed up my connection to this
server? At the moment, we are still in the testing phase and I am
running this over a 100Mbps connection, so any changes are up for grabs.

Should I change this to PHP? Will that help any at all? 

Is this database just going to get too big for it to be quick over the
Web? 

Any information needed will be immediately posted. 

Thank you so much! 

J.R. Bullington 
Innovatim Technical Support 
[EMAIL PROTECTED] 

... 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Very big IN ( $value )

[Knepley, Jim]

I've had tens of thousands of items in an IN list without failure, but
it seems that when you get that many it takes a very long time to parse.

The speed thing bothers me, so I'm toying with a new design, but it's a
big enough system that it's slow going.

J


-Original Message-
From: Batara Kesuma [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 28, 2004 4:00 AM
To: [EMAIL PROTECTED]
Subject: Very big IN ( $value )

Hi,

I do my query from Perl DBI, it has a very big IN ( $value ).
The query looks like:
SELECT id FROM user
WHERE sex='m' 
AND hobby_id='3'
AND id IN ( $value );

$value looks like:
102, 233, 445, 543 ... 3443, 332 very long list.

It might be about 10,000 id in $value. What is the maximum value I can
pass in a query? Is this the right way to do it? (I mean, using a very
big value inside IN)

Thank you,
--bk

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL 4.1 Production Release

[Knepley, Jim]

Any chance that there's a quarterly strategic roadmap published
somewhere?

I have projects that sometimes depend on a feature in the next rev' or
some such, and I need to plan out for my organization... Difficult to
answer my boss when the dependencies are released when they're ready.



-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 06, 2004 5:25 AM
To: Allen Weeks
Cc: MySQL List
Subject: Re: MySQL 4.1 Production Release

On Mon, 5 Jan 2004, Allen Weeks wrote:
 Hi All,

 Just a quick question, does anyone have a good estimate of when ver 
 4.1 will go production.

When known bugs are fixed.
You can read up on MySQL's release policy here:
http://www.mysql.com/doc/en/Release_philosophy.html


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Null-safe equal help, please

[Knepley, Jim]

The query in question:

SELECT switch, hostname, INET_NTOA(it_iFace.ip) AS IP, location,
contact, port
FROM cam
LEFT JOIN iFace ON ( switch = it_iFace.hostID )
LEFT JOIN host USING ( hostID )
LEFT JOIN arp ON ( cam.mac = arp.mac )
WHERE arp.ip = if( ip = ,NULL,INET_ATON(ip) );

(both instances of ip are the same value in this case)
If IP is empty, this returns an empty set, if IP exists it gives me what
I expect.

Simplifying the query so the WHERE clause reads:
WHERE arp.ip = NULL
...returns an empty set.

Whereas:
WHERE arp.ip IS NULL
...returns tens of thousands of records.




-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 8:44 AM
To: Knepley, Jim
Cc: [EMAIL PROTECTED]
Subject: RE: Null-safe equal help, please

Please reply to the list so that others can follow this discussion.
Thanks.

At 8:26 -0700 12/17/03, Knepley, Jim wrote:


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please

At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL

That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL

The manual, and my testing, shows that NULL = NULL evaluates to 1,
so

Are you saying that this is not what you expect?  Why not?

It is what I expect, but it doesn't seem to be the behavior.

You indicated before that your own testing shows that NULL = NULL
evaluates to 1.

You now say that this *doesn't* seem to be the behavior.

I don't follow you.


snip


What I _really_ want to do is this:
WHERE  possibly_null_value = INET_ATON(IP)

...so that if no IP is specificied it'll return those 
possibly_null_value columns that are, in fact, NULL.

Your requirements are unclear.  I can see two ways to interpret that
statement:

1) You want only possibly_null_value values that are NULL.
2) You can possibly_null_value values that are NULL *and*, if IP is
specified, possbly_null_value
values that are equal to INET_ATON(IP).

Those are not the same thing.  (In other words, it's clear what you
want only for the case that IP is NULL.  It's not clear what you want 
when IP isn't NULL.)  Can you clarify?

I can see where I was unclear, as I had simplified the statement (in an

attempt to be more clear, go figure). I'm looking for case 2 that you 
described.

In that case, it looks to me (without knowing more) that the statement
you show above should do what you want.  It apparently does not, so
perhaps you could post to the list a few combinations of
possibly_null_value and IP values. Indicate what results you get, and
how that differs from what you expect.


snip

Thanks for your time on this.

Cheers,
 Jim


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified?  http://www.mysql.com/certification/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Null-safe equal help, please

[Knepley, Jim]

 

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please

At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL

That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL

The manual, and my testing, shows that NULL = NULL evaluates to 1,
so

Are you saying that this is not what you expect?  Why not?

It is what I expect, but it doesn't seem to be the behavior.

snip


What I _really_ want to do is this:
WHERE  possibly_null_value = INET_ATON(IP)

...so that if no IP is specificied it'll return those 
possibly_null_value columns that are, in fact, NULL.

Your requirements are unclear.  I can see two ways to interpret that
statement:

1) You want only possibly_null_value values that are NULL.
2) You can possibly_null_value values that are NULL *and*, if IP is
specified, possbly_null_value 
   values that are equal to INET_ATON(IP).

Those are not the same thing.  (In other words, it's clear what you
want only for the case that IP is NULL.  It's not clear what you want
when IP isn't NULL.)  Can you clarify?

I can see where I was unclear, as I had simplified the statement (in an
attempt to be more clear, go figure). I'm looking for case 2 that you
described.

snip

Thanks for your time on this.

Cheers,
Jim


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Null-safe equal help, please

[Knepley, Jim]

I've got a WHERE clause:
WHERE possibly_null_value IS NULL
 
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
 
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
my now-fevered mind sees no reason the two above statements are not
equivalent.
 
What I _really_ want to do is this:
WHERE  possibly_null_value = INET_ATON(IP)
 
...so that if no IP is specificied it'll return those
possibly_null_value columns that are, in fact, NULL.
(Just as a test I've also tried possibly_null_value = NULLIF(
ISNULL(INET_ATON(IP)), 1 ), which is wrong for my app, but still
broken)
 
MySQL 4.0.15-standard
 
Any insight would be much appreciated.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

WHERE IN performance

[Knepley, Jim]

Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause, even when the matching
field is indexed.
 
Is this something that buffer tweaks can mitigate, or am I looking at a
more fundamental issue with how IN in implemented?
 
J

compressed MyISAM Table Formats

[Knepley, Jim]

http://www.mysql.com/doc/en/MyISAM_table_formats.html
In the future you will be able to compress/decompress tables by
specifying ROW_FORMAT=compressed | default to ALTER TABLE.
 
Anyone know when this future is?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Wildcards not allowed in GRANT commands for table names?

[Knepley, Jim]

The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
 
security.ids_events
secuirty.ids_correlations
etc.
 
My tests at giving a user rights to 'security.ids_% (even by directly
editing the tables_priv table) haven't worked out.
Is this genuinely not possible or am I missing something?

Updating a nested set

[Knepley, Jim]

I'm basing some work on Joe Celko's excellent idea of using nested sets
to represent an organizational structure as opposed to an adjacency
list. By and large it's a great idea, but not without its pitfalls. I'm
writing now to ask your collective opinion of the best practice.

I've got my nested set table, and since the left bound is unique, I'm
using it as a foreign key to the table that contains assignment
information. The problem is that if I add an element to the middle of
the nested set, the left bound change on the elements to the right of
the insert. This requires an update of the foreign key on the assignment
table.

I see two options:
1. Update the foreign key on the assignment table with a multi-table
UPDATE as I nudge the necessary left bounds:

UPDATE elements, assignments
SET lft = IF( lft   ?, lft + 2, lft ),
rgt = IF( rgt = ?, rgt + 2, rgt ),
assignments.id = IF( id   ?, id + 2, id )
WHERE rgt = ?;
(given that '?' is the right node of the parent entitiy)

2. Don't use the left bound as the foreign key. While this seems
straight forward, it complicates queries like all assignments for this
element and it's sub-elements.

I'm leaning toward #1, but I have the nagging feeling that it's more
complex than the example query is able to manage.
There could be a solution I haven't considered, as well... I'd love to
learn about it.

__

Jim Knepley
Network Security Engineering
x88321

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: query help!!!

[Knepley, Jim]

You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04;
oe=UTF-8output=gplain

Cheers,
Jim


-Original Message-
From: bruce [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 13, 2003 7:29 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: query help!!!


Hi...

I have a questiona problem actually!!!

I'm trying to figure out how to determine the descendents of a given
child would be. The table defs are...:

CREATE TABLE ItemTbl
(
id int(5) NOT NULL auto_increment,
itemnamevarchar(25) NOT NULL default '',
unique (itemname),
PRIMARY KEY  (id)
)   TYPE=MyISAM;


#
#   assettypetbl
#
#   b. douglas july 10,03
#   added status. allows user from web to modify the asset obj
#   type. user is able to set items within an asset type
#   to be added/deleted from asset type.
#
#
#   Used to store the name/parentid of a given item. the table is
used
#   in conjunction with the ItemTbl. This table permits duplicate
#   item names, as a given item can be a child of multiple parent
items.
#   In other words, the item can belong to multiple item structures
#
#
#   The table contains the following information:
#
#   itemnamevarchar(25) NOT NULL default
'',(this gets the image/thumb)
#   parent_id   int(5) NOT NULL default '',
#

CREATE TABLE atbl
(
itemnamevarchar(25) NOT NULL default '',#(this
gets the image/thumb)
parent_id   int(5) NOT NULL default '',
)   TYPE=MyISAM;


#
#   test data
#
insert into itemtbl (itemname) values ('tire');
insert into itemtbl (itemname) values ('rim');
insert into itemtbl (itemname) values ('hub');
insert into itemtbl (itemname) values ('wheel');
insert into itemtbl (itemname) values ('car');
insert into itemtbl (itemname) values ('engine');
insert into itemtbl (itemname) values ('window');
insert into itemtbl (itemname) values ('airplane');

insert into atbl (itemname, parent_id) values ('tire', 4); insert into
atbl (itemname, parent_id) values ('rim', 4); insert into atbl
(itemname, parent_id) values ('hub', 4); insert into atbl (itemname,
parent_id) values ('wheel', 5); insert into atbl (itemname, parent_id)
values ('car', 0); insert into atbl (itemname, parent_id) values
('engine', 5); insert into atbl (itemname, parent_id) values ('window',
5); insert into atbl (itemname, parent_id) values ('airplane', 0);
insert into atbl (itemname, parent_id) values ('wheel', 8);

The atbl contains the parent item relationships... for the items...

Baisically, I need a way of determining what the
parents/grandparents/great-grandparents/etc... are for a given item
My concern is that a user might add an item and a parent, and I would
get into an item being a parent of itself...

So..does anyone have a good way that I could create a query to generate
the descendents of a given item??

Thanks for any pointers/information that might help!!!

Regards,

Bruce
[EMAIL PROTECTED]
(925) 866-2790







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: recursive sql statement

[Knepley, Jim]

See http://www.mysql.com/doc/en/TODO_future.html
Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical)
structures.

Whatever their definition of The Near Future is... I'd guess v5

J

- Original Message - 
From: Bernhard Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 2:58 AM
Subject: recursive sql statement

hi
i searched the mysql doc for support of recursive sql statements, but
found nothing. i am right that mysql does not support such kind of
statements?
best regards
benny


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: very long query time

[Knepley, Jim]

I have had similar performance concerns, but on a much smaller scale.
The data was well indexed, but took far too long to query (particularly
with aggregate queries).
 
Check the individual row size of your table. In my case, I had a TEXT
field that would frequently be fairly long. Moving that field to another
table and indexing back resulted in a massive performance improvement. A
query that would take minutes now takes less than a second. I figured it
was a question of IO latency, and moved on.
 
J

-Original Message-
From: Maurice Coyle [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 27, 2003 3:35 AM
To: [EMAIL PROTECTED]
Subject: very long query time


hi all,
i have a table in my mysql database with around 66 million rows in it.
when i query this table, it takes anywhere from 3 minutes to 10 minutes
to return the results.  i've tried this both from within the mysql
command line and from java programs.
 
Section 1.2.4 in the manual says the maximum table size is 4Gb and when
i use the show status command for this table, it says the data_length is
1,585,947,820 and the max_data_length is 4,294,967,295, so the table
size seems to be well within the limit.
 
The results for a query to this table can contain up to 11500 hits, so
maybe this is the problem?  If there's no fix for this, does anyone know
how i can query for only the top 100 results, say?
 
i can't see what's wrong, can anyone shed some light on this
problem/offer the benefit of your experience in similar matters? i'd
really appreciate it if you could.
 
thanks,
maurice


 http://www.incredimail.com/redir.asp?ad_id=309lang=9
IncrediMail - Email has finally evolved - Click Here
http://www.incredimail.com/redir.asp?ad_id=309lang=9  

RE: mySQL GUIs

[Knepley, Jim]

Nils, and other well meaning members who mail me directly:
(B
(BI subscribe to the digest for a reason, please do not copy me directly on replies.
(BYes, I'm guilty of doing this myself... Live and learn.
(B
(B
(B-Original Message-
(BFrom: Nils Valentin [mailto:[EMAIL PROTECTED] 
(BSent: Thursday, June 12, 2003 9:16 AM
(BTo: Adam Nelson; Knepley, Jim; 'Rodolphe Toots'; [EMAIL PROTECTED]
(BSubject: Re: mySQL GUIs
(B
(B
(BHi Jim  Mysql List members,
(B
(Bsad to hear that there are still people around not using a propper OS ;-) - 
(Blike a Linux, BSD  or Unix based OS. 
(B
(BAnyway as you asked about the best GUI for accesing MySQL - and as you asked 
(Bthe question you know there is only one best GUI ;-).  Anything mentioned 
(Bbelow is my personal opinion and I am ot related to tany of the parties 
(Bmentioned. Any welcome to fire back on me ;-)
(B
(BEMS's MySQL Mangaer is to heavy loaded and the interface is anything else then 
(Bintuitive - so kick it into the bucket ;-)
(B
(BThere are many such tools around to be honest, but my absolute favourite one  
(Bhas to be DbVisualizer (www.minq.se) with a loong distance second .
(B
(BThat has very good reasons which I am willing to explain.
(B
(Ba) First the Menu is intuitive AND context sensitive.
(Bb) its fast
(Bc) it works
(Bd) its java
(Be) its professionally done
(Bf) contains a chart software (yfiles from www.yworks.com)
(Bg) support replies under 10 minutes !! REGULARLY
(Bh) its not a windows copy GUI ;-)
(Bi) two license model
(Bj) any major OS supported
(B
(B
(BAbout a) I want to explain a bit more. When you choose data and go to the 
(Bexport menu it will offer you to export as html or csv. If you choose to 
(Bexport the diagramme it will offer as choice jpeg or gif. So the menu changes 
(B(in the background) and you dont have to think about it. It also takes the 
(Bmillions off not needed options out of the menu  simpler.
(B
(BOf course there is more but I believe that I gave enough good reasons ;-)
(B
(BI have no clue why MySQL is partnering with EMS ;-), but I strongly believe 
(Bthat DbVisualizer is the best around.
(B
(BIf anybody believes that another tool is better than I would be VERY 
(Binterested to hear about it.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(B
(B
(B
(B2003$BG/(J 6$B7n(J 12$BF|(J $BLZMKF|(J 23:21$B!"(JAdam Nelson 
$B$5$s$O=q$-$^$7$?(J:
(B I like MySQL Manager - it costs a bit of money, but I find it 
(B indispensible.
(B
(B www.ems-hitech.com
(B
(B It runs on Windows AND Linux.  I'll be switching to the linux version 
(B in about two weeks, so I'll tell you how well it works.
(B
(B  -Original Message-
(B  From: Knepley, Jim [mailto:[EMAIL PROTECTED]
(B  Sent: Wednesday, June 11, 2003 3:00 PM
(B  To: Rodolphe Toots; [EMAIL PROTECTED]
(B  Subject: RE: mySQL GUIs
(B 
(B 
(B  I'm a big fan of Scibit's "Mascon"
(B 
(B 
(B 
(B  -Original Message-
(B  From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
(B  Sent: Wednesday, June 11, 2003 5:17 AM
(B  To: [EMAIL PROTECTED]
(B  Subject: mySQL GUIs
(B 
(B 
(B  hi!
(B 
(B  i am looking for a good mySQL gui for windows
(B  i have used mySQL front, which was an excellent free program, but i 
(B  did not handle relations and diagrams. also the program is no longer 
(B  being developed
(B 
(B  i have now found the prog mySQL tools (http://www.mysqltools.com/) 
(B  and mySQL explorer that works almost as enterprise manager for MS 
(B  SQL server. it even creates database diagrams with relations as in 
(B  enterprise manager! only backdraw is that this program is not free, 
(B  but it is the best i have ever seen so far
(B 
(B  is there anyone out there that knows of a program that is 
(B  freeware/shareware and is good (like mySQL tools)?
(B 
(B 
(B 
(B  /rewdboy
(B
(B-- 
(B---
(BValentin Nils
(BInternet Technology
(B
(B E-Mail: [EMAIL PROTECTED]
(B URL: http://www.knowd.co.jp
(B Personal URL: http://www.knowd.co.jp/staff/nils
(B
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mySQL GUIs

[Knepley, Jim]

I'm a big fan of Scibit's Mascon



-Original Message-
From: Rodolphe Toots [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 5:17 AM
To: [EMAIL PROTECTED]
Subject: mySQL GUIs


hi!

i am looking for a good mySQL gui for windows
i have used mySQL front, which was an excellent free program, but i did
not handle relations and diagrams. also the program is no longer being
developed

i have now found the prog mySQL tools (http://www.mysqltools.com/) and
mySQL explorer that works almost as enterprise manager for MS SQL
server. it even creates database diagrams with relations as in
enterprise manager! only backdraw is that this program is not free, but
it is the best i have ever seen so far

is there anyone out there that knows of a program that is
freeware/shareware and is good (like mySQL tools)?



/rewdboy

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]