Are there any programs with gui that allow you to create a MySQL database, create tables, define primary and foreign keys, and insert data? I'm tired of having to use the mysql command line client, very tedious.
I suggest you use phpMyAdmin . There is also a MySQL Workbench .
MySQL
PostgreSQL
Oracle
SQL Server
, :
SQLYOG
Navicat
SQLyog Community Edition . Community Edition is free and open source under the GPL.
If you're using Mac OSX, I highly recommend http://www.sequelpro.com/ (it's free and awesome).
Toad free and very powerful