Changes

Creating New Databases and Tables with MySQL Administrator

625 bytes added, 19:28, 27 September 2007
Creating a New Database
The columns in the table may be viewed and modified by selecting the desired table in the list and clicking the ''Edit Table'' button.
 
In order to create a new database, simply move the mouse pointer to any area of the ''Schemata'' list, click with the right hand mouse button and select ''Create Schemata'' from the popup menu. In the resulting ''Create Schema'' dialog, enter a name the new database. For the purposes of this tutorial we will use the name ''myDBase''. Click on ''OK'' to initiate the schema creation.
 
If the new database is not currently selected in the ''Schemata'' list, select it and note that the view area now changes and shows no tables. The next task, therefore, is to create a table in our new database.
 
== Creating New Tables ==