MySQL Database Design
Make your script Sql
The MyA (Make Your Application) is based on Database Design and creation of Script SQL:
- Data types
- Primary Key
- Unique Key
- Foreign Key
You can use WWW SQL Designer that is a web based visual SQL modeling tool that allows
you to draw E-R designs, edit tables and rows, manage keys, create
relations (FK constraints), save & load designs and import DB
schemas. WWW SQL Designer is available into Posticcibook.
Posticcibook use MySQL for data storage into Web based Application . Due to its
popularity and open source business model, numerous tools and
utilities are available that will help you easily design and manage
your MySQL databases.
W3Avenue has compiled a list of really useful free tools and
utilities for MySQL that will enable you design and manage your
databases of various scope and complexity.
Free tools for Database Design
MySQL Workbench is a cross platform GUI product for the MySQL Server
that can be used to write and execute SQL queries and scripts, edit
data, visually design database models and manage
the MySQL Server.
- SQuirreL SQL
SQuirreL SQL Client is a graphical SQL client written in Java that
will allow you to view the structure of a JDBC compliant database,
browse the data in tables, issue SQL commands etc.
- Toad for MySQL
Toad for MySQL is database development and administration tool that
enables: query development, database design, database
administration, data management, reporting, project management and
MyDB Studio is a collection of powerful tools for MySQL Server
administration. It also supports SSH tunneling to secure your
connections enabling you to connect even if your host doesn’t
allow you remote access connection.