MesaMySQL

GUI for MySQL Databases
Download

MesaMySQL Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Commercial
  • Price:
  • $20.00
  • Publisher Name:
  • Desert Sand Software
  • File Size:
  • 3.6M

MesaMySQL Tags


MesaMySQL Description

MesaMySQL makes creating, designing, and altering a MySQL database easy and fun. We also use it to edit, summarize, and analyze data for ourselves and clients. Main 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, and delete tables to any database Specify table type View, add, duplicate, 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 Viewing and Editing Content: Select encoding for viewing your data - encodings: UTF8, Win Arabic, Win Baltic Rim, Win Cyrillic, Win Greek, Win Korean, 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 Reset column widths for easier viewing after a recordset loads with one click View totals of numeric columns in a recordset with one click Add and edit records directly in the listbox view Delete records directly from the listbox view Multi-select adjacent or non-adjacent rows for deletion or global editing Click and drag in the recordset listbox to select cells and make them available to the clipboard Reorder columns of data using click-and-drag without changing the structure of the table Special Queries: Type any query into the custom query field Read errors and rows returned associated with a custom query View nearly 200 (MySQL version related) server-side variables with one click Perform Optimize, Anayze, Check, and Repair functions on tables View threads (connections) to the server Kill a thread that has orphaned a table lock or record lock Store favorite queries and keep a history of recent queries Users: View users and their privileges Add users and set their privileges Set or change passwords for users (including "root") if you are running locally or you have access to the users table of the mysql database Edit a users privileges on the server, database, or table Exporting and Importing Data: Export a proprietary dump to back-up the structure and content of the database Export the content screen, custom query result, or table as a csv, tab, or xls file Import a proprietary dump that can recreate the database from a single file Import any csv, tab, or xls file into a given table


MesaMySQL Related Software