Home arrow MySQL arrow Page 3 - MySQL Made Easy With MySQL Front

MySQL Made Easy With MySQL Front

MySQL Front allows anyone to easily create and manage their MySQL databases. In this tutorial Ryan shows us how to get up and running with MySQL Front.

Author Info:
By: Ryan Schwiebert
Rating: 5 stars5 stars5 stars5 stars5 stars / 55
May 30, 2002
  1. · MySQL Made Easy With MySQL Front
  2. · Connecting to the database
  3. · Adding Tables
  4. · Conclusion

print this article

MySQL Made Easy With MySQL Front - Adding Tables
(Page 3 of 4 )

Adding tables to the MySQL database is as easy as creating the database. First, click on the "Create Table" button on the toolbar. In the dialog box that follows, give your table a name as well as a brief description. With the areas provided below, MySQL Front allows you to create the initial fields for your table, as well as set their attributes.

Creating tables

Once you have completed adding the desired fields, you may click "Create!" to save this information to your database.

Adding More Fields
You may later choose to add additional fields to your table. This is accomplished with the following steps:
  1. Expand the database you wish to make changes to by clicking the [+] sign next to it.
  2. Select the table that you wish to add the additional fields to.
  3. Ensure that the table tab is selected.
  4. Click the "Add Field" button.
Adding fields to a table

In the dialog box that follows, you will be able to add the desired fields to the table in any order you wish. Making changes to existing fields, and dropping fields can also be accomplished from the same "Table" tab within MySQL Front in an almost identical fashion.

Viewing, Editing, and Deleting Data
Manipulating data is also simplified through the use of MySQL Front. To work with the MySQL data, simply click on the "Data" tab. In this area, you will see the data displayed in a familiar spreadsheet-like format. To edit an existing record, simply click on the desired field and key in the new information.

Adding a new record is accomplished by clicking the plus sign found near the bottom of the screen. This will invoke a new row for you to enter data into. After entering or editing data, be sure to press the enter key or click the check mark near the bottom of the screen to save your entry to the table.

Running SQL Queries
As you continue to work with MySQL Front, you may begin to notice the SQL statements that are displayed along the bottom portion of the screen. These statements are automatically created by MySQL Front as you type and click buttons in the interface.

Running queries

Another powerful feature built into MySQL Front is the SQL query builder. This feature makes running and testing your own SQL queries much easier. To author and execute MySQL Queries, click on the "Query" tab near the top of MySQL Front window.

There are numerous benefits to this feature. The interface allows you to load SQL queries from a file, such as the ones accompanying many of the DevArticles tutorials. In this area, you also have the ability to save complex queries to a file so that they may be used again when they are needed. Additionally, the query builder is useful for writing and testing your own SQL statements. There is even a button provided to insert a variety of functions into your SQL statements.

Please note that it is possible to do damage to the data in your MySQL database using this feature. There is no undo function, so type your SQL statements carefully. If you are not familiar with how to properly author SQL queries, you might wish to take a look at SQL In Simple English part 1 and part 2.
blog comments powered by Disqus

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials