Hi,

I find it tedious to write SQL once I have designed a database. Is there any software out there that will let me automatically generate SQL (specificaly for mySQL databases) once I have made tables and relationships? I have Visio but I don't think it will let me generate SQL once I have made the database diagram...

Thanks.

NB

There are a lot of administrative and visual interface for creating and designing MySQL databases on the market....for example EMS MySQL manager from EMS Hi-TEch...you can also download a 30 days trial version from their web site...and of course you can use free softwares such as myadmin a PHP based software for MySQL Administration.....Just check them with a search engine like google...you will find plenty of them both free and not free...

Thanks, I'll check it out

>I find it tedious to write SQL once I have designed a database
Then I'd say you are in the wrong profession.
Please explain how some mythical/magical "tool" can KNOW what is to
be done with the data in the database. Simply being aware that a parent/child
relationship exists, provides nothing of value to what the business rules are or should be.

I think they call that ErWin.

-PatP