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.
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:
Expand the database you wish to make changes to by clicking the [+] sign next to it.
Select the table that you wish to add the additional fields to.
Ensure that the table tab is selected.
Click the "Add Field" button.
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.
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 Englishpart 1 and part 2.