I used WWW SQL Designer several times to design databases for applications. Now I am responsible for working with an application with a large number of tables (100+ mysql tables), and I would be interested to look at the relationship between the tables as WWW SQL Designer suggests. It seems that it contains provisions that allow you to connect to the database and present a diagram of its structure, but I have not yet been able to determine exactly how to do this.
http://code.google.com/p/database-diagram/
This takes an SQL structure (SQL dump) and shows a chart :)
, , ( ): backend/php-mysql/index.php . , , - , .
function setup_import() { define("SERVER","localhost"); define("USER",""); define("PASSWORD",""); define("DB","information_schema"); }
SQL-, , WWW SQL Designer? ...
, , PHP/MySQL, " " "/".
VISIO , .
btw, have you tried SchemaBank ? They are web based and support MySQL pretty well. It eats your sql dump and generates tables and relationships for you.
Source: https://habr.com/ru/post/1697351/More articles:Seam / JSF form presents onclick start button - javaКак правильно добавить на страницу с jquery и позволить событию изменения работать? - jqueryScriptaculous Droppables onDrop callback; How to refer to each element? - javascriptВнутреннее соединение через множественный доступ db - inner-joinCan you recommend a Windows-based network emulator? - networkingHow to unload an external SWF file from a SWFLoader component in Adobe Flex? - flexHow your company sponsors programming certification - promotionsWhat is the OleDb equivalent for INFORMATION_SCHEMA - sqlCan you use Silverlight with AJAX without any interface element? - javascriptWebsite Login Module - loginAll Articles