We built MesaMySQL for ourselves. MesaMySQL makes creating, designing, and altering a MySQL database easy. We also use it to edit, summarize, and analyze data for ourselves and clients. Although we build new databases most days, we spend more of our time viewing and editing data. MesaMySQL is set up for this in mind.
MesaMySQL connects to MySQL servers version 3.23 to 5.1
The database that drives this website was built with MesaMySQL.
Here is an overview of MesaMySQL features:
Connections
Connect to a database on your machine or over the internet
Open a new connection with each new window
Open multiple connections to the same database
Open connections to multiple databases on the same server
Do both of the above at the same time
Store your connections and specify a default connection
Structure
View, add, and delete databases
View, add, duplicate, rename, and delete tables
Specify table type
View, add, duplicate, rename, edit, and delete fields on tables
Specify field type, length, unsigned, zerofill, nullable, default value, and autoincrement
Add and delete indexes on tables
View the Create Table sql syntax for your tables
Select encoding for viewing your data - encodings: UTF8, Win Arabic, Win Baltic Rim, Win Cyrillic, Win Greek, Win Latin 1, Win Latin 2, Win Vietnamese, K018-R, Shift-JIS, ISO Arabic, SO Cyrillic, ISO Greek, ISO Hebrew, ISO Latin 1, ISO Latin 2
Limit the number of records that load upon table selection
Suppress autoloading of records upon table selection
Build query to limit records using dropdown menus
Limit a recordset from a table by selecting a record count and a starting record
Set a "Load Last" limit that will load the last "n" records in the table
Limit the columns returned in a recordset
Sort a recordset by multiple fields
Make global changes to many records in a showing recordset
