Home Mysql MySQL Create Database
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

MySQL Create Database

Advertisement
The MySQL Table Editor is a component of both the MySQL Query Browser and MySQL Administrator, enabling the visual creation and modification of tables.

MySQL Create Database

     

  1. MySQL Table Editor
    The MySQL Table Editor is a component of both the MySQL Query Browser and MySQL Administrator, enabling the visual creation and modification of tables. The MySQL Table Editor can be accessed from the MySQL Query Browser by right clicking on a table within the database browser and choosing the Edit Table option, or by right clicking on a database within the database browser and choosing the Create New Table option.  The MySQL Table Editor can be accessed from MySQL Administrator through the Catalogs screen. Once you have selected a database, right click on a table and choose the Edit Table option from the drop-down menu. 
       
  2. MySQL Editor
    Navicat is an intuitive GUI tool lets you create, browse databases and run SQL queries in an easier way. Advanced features include visual query builder, report builder, backups/ restore, batch job scheduling, remote connecting, and the ability to easily migrate data to/from Excel, Access and other data formats. Other features include a SQL Console, View Builder and Data Synchronization. The latest version supports HTTP connection. SQL Mage for MySQL is a powerful SQL editor, which provides various possibilities for database users, developers and administrators. Besides all standard operations with databases, SQL Mage allows to print out the list of databases, fields of the specified table, data and even SQL scripts, preserving their original font and colour. The editor itself is designed as a set of tabs .
      
  3. MySQL/PHP Table Editor
    A PHP 4 & 5 library to allow easy and user-friendly editing of MySQL tables. Note this is a library and not an application. It will be of no use unless you do some coding . There are some features include here:-
    * Now (as of 1.0.5) works with both PHP4 and PHP5 
    * Easy setup. Give it a connection resource and a table name and it will work most things out by itself. 
    * Search functionality (albeit basic MySQL LIKE). Can be disabled (default), and limited to certain fields only. Advanced Search (version 1.0.6) can be used to search specific fields only, or with various operators (LIKE, =, >, >=, <, <=). 
    * View/Add/Copy/Edit/Delete functionality, any or all of which can be disabled. 
    * CSV download for selected rows, current page or entire table. Can be disabled. (Version 1.0.6). 
      

  4. MYSQL Query Browser
    MySQL Query Browser is the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries. Plus, the integrated environment provides: *Query Toolbar to easily create and execute queries and navigate query history  *Script Editor giving you control to manually create or edit SQL statements  *Results Window so you can also easily compare and work with multiple queries  *Object Browser enabling you to manage your databases, bookmarks, and history using a Web Browser like interface  *Database Explorer where you can select tables and fields to query, as well as create and delete tables  *Table Editor allows you easily create, modify and delete tables  *Inline Help giving you instant help access to selected objects, parameters, and functions

       
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 18, 2008

Ask Questions?    Discuss: MySQL Create Database   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
rupesh kumar panda
September 17, 2011
sql

plz tell me query,delete data from table
Avinav
July 9, 2012
oracle

nice
Hannah
August 26, 2012
ZhDMjeWhvrToAd

Taking the ovrvieew, this post hits the spot
DMCA.com