Re: [Phplib-users] Re: [phpslash-users] Hello -- I could use some help

[Michael C. <mdc...@mi...>]

On Thu, Nov 07, 2002 at 11:21:41AM -0500, Rob Hutton wrote:
>   There is no way in MySQL to do it automagicly because there is no foreign
> key support.  Even if they didn't actually enforce data integrity rules, it
> would be nice to have them just because of the modeling.
>   That said, I do most of my modeling for simple stuff in *choke* Visio.  It
> will read the table definition through odbc and then you can drop the
> relationships in failry easily.

Another product, and the only Microsoft software product that I ever
recommend, is Access.  Hate it if you want, but it does allow you to
draw the relationships between tables and design queries, even queries
that are too complex for MySQL, quite easily.  It's almost 100% SQL-89
compliant.

Just please don't use it for programming.  Reporting, modeling (to an
extent), and ad-hoc querying are pretty strong, and last I bought it it
was still $99.

Michael
-- 
Michael Darrin Chaney
mdc...@mi...
http://www.michaelchaney.com/