将现有数据库加载到 WWW SQL Designer 中?

发布于 2024-07-06 01:58:12 字数 234 浏览 8 评论 0原文

我曾多次使用 WWW SQL Designer 来为应用程序设计数据库。 我现在负责开发一个包含大量表(100 多个 mysql 表)的应用程序,我希望能够以类似于 WWW SQL Designer 提供的方式查看表之间的关系。 似乎它附带了连接数据库并提供其结构图的规定,但我还无法确切地弄清楚如何做到这一点。

I've used WWW SQL Designer several times to design databases for applications. I'm now in charge of working on an application with a lot of tables (100+ mysql tables) and I would love to be able to look at the relations between tables in a manner similar to what WWW SQL Designer provides. It seems that it comes with the provisions to hook up to a database and provide a diagram of its structure, but I've not yet been able to figure out exactly how one would do that.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(6

顾冷 2024-07-13 01:58:12

我知道这确实是旧东西,但我找到了解决方案(如果人们正在寻找它):您必须编辑文件 backend/php-mysql/index.php 并填写连接设置。 您所需要的只是单击从数据库导入,然后使用数据库名称加载

function setup_import() {
    define("SERVER","localhost");
    define("USER","");
    define("PASSWORD","");
    define("DB","information_schema");
}

I know this is really old stuff, but I found the solution (if people are looking for it) : you have to edit the file backend/php-mysql/index.php and fill the connection settings. All you need is then to click on Import From DB, and then Load with the name of your database.

function setup_import() {
    define("SERVER","localhost");
    define("USER","");
    define("PASSWORD","");
    define("DB","information_schema");
}
江湖彼岸 2024-07-13 01:58:12

http://code.google.com/p/database-diagram/

这个采用 SQL 结构(SQL 转储)并显示图表:)

http://code.google.com/p/database-diagram/

This takes a SQL structure (SQL dump) and shows a diagram :)

喜爱纠缠 2024-07-13 01:58:12

您可以导出构建现有表的 SQL 查询,然后在 WWW SQL Designer 中运行它吗? 大多数数据库管理软件都有这个选项...

Can you just export the sql query that builds your existing tables, and run that in WWW SQL Designer? Most database management software has that option...

清秋悲枫 2024-07-13 01:58:12

看看设计器的界面,我想当您在自己的 PHP/MySQL 服务器上运行它时,您应该能够使用“保存/加载”对话框中的“从数据库导入”按钮导入现有数据库。

Looking at the interface of the designer, I guess that when you run it on your own PHP/MySQL server, you should be able to import existing database with "Import from DB" button in Save/Load dialog.

深陷 2024-07-13 01:58:12

您可以使用VISIO导入数据库,它会为您绘制图表。

You could use VISIO to import the database, it will diagram it for you.

浪推晚风 2024-07-13 01:58:12

顺便说一句,您尝试过 SchemaBank 吗? 它们是基于网络的并且很好地支持MySQL。 它会吃掉你的 sql 转储并为你生成表和关系。

btw, have you tried SchemaBank? They are web-based and support MySQL fairly well. It eats your sql dump and generates the tables and relationships for you.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文