MySQL Database Query Tool Features

The MySQL database query tool features provided by RazorSQL include a custom database browser tailored to MySQL, a MySQL SQL editor with MySQL specific features and syntax highlighting, custom MySQL visual tools, and MySQL specific database administration tools. Listed below are more details on these features.

MySQL Visual Tools

  • A MySQL create table tool that generates MySQL specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, auto increment, enumeration, and MySQL database engine type such as InnoDB or MyISAM
  • A MySQL create view tool that generates the SQL for creating MySQL views
  • A MySQL create index tool that generates the SQL for creating MySQL indexes and includes elements such as index name, uniqueness, and columns
  • A MySQL create procedure tool for MySQL version 5 or later for generating the SQL to create MySQL procedures
  • A MySQL create function tool for MySQL version 5 or later for generating the SQL to create MySQL functions
  • A MySQL create trigger tool for MySQL version 5 or later for generating the SQL to create MySQL triggers
  • A MySQL create database tool that generates the MySQL create database SQL with elements such as database name, collation, and character set
  • A MySQL create user tool that generates the MySQL create user SQL with elements such as user name, password, privileges, database access, domain access, and grant options
  • A MySQL alter table tool for generating the SQL to alter MySQL tables with such options as add column, add primary key, add foreign key, add constraint, rename table, rename column, drop column, drop primary key, drop foreign key, and drop constraint
  • A MySQL alter view tool for generating the SQL to alter MySQL views
  • SQL Drop Tools for dropping tables, views, procedures, functions, triggers, databases, and users for MySQL
  • A visual edit table tool for visually editing MySQL tables in a spreadsheet format
  • Tools for editing procedures, functions, and triggers for MySQL version 5 or later
  • MySQL Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
  • A MySQL SQL Explain Plan tool

MySQL Database Browser

  • Displays information in a tree format for databases, tables, views, procedures, functions, triggers, indexes, constraints, and users
  • Displays MySQL table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • A MySQL View DDL option for viewing the create table SQL for tables and the create view SQL for MySQL views
  • Easily view table contents or database object information via the View Contents and Show Info context menu options