Are there any programs with a gui which let you create a MySQL database, create tables, define the primary and foreign keys and insert data? I am tired of havi开发者_StackOverflow社区ng to use the mysql command line client, very tedious.
I suggest you use phpMyAdmin. There is also MySQL Workbench.
- MySQL Query Browser (
MySQL
) - pgAdmin III (
PostgreSQL
) - Allround Automations PL/SQL Developer (
Oracle
) - SQL Server Management Studio (
SQL Server
)
these app arn't free but useful :
SQLYOG
Navicat
SQLyog Community Edition. The Community Edition is Free & Open Source under GPL license.
If you happen to be using Mac OSX, I highly recommend http://www.sequelpro.com/ (it's free and awesome).
Toad is free and very powerful
精彩评论