Changes

The area in the bottom left hand corner of the screen entitled ''Schemata'' lists the databases currently under the control of the database server to which the administration client is currently connected. Selecting any existing entry in this list will list the tables contained within that database. In the above figure, a pre-existing database named ''PHPsampleDB'' is selected, which is shown to contain a single table named ''customer'' which contains 5 columns.

)

ENGINE = MyISAM;

</pre>

Click the ''Execute'' button and wait for the ''Table Created'' dialog to appear. Dismiss this dialog and return to the MySQL Administrator Catalog screen and note the myDBase database now contains a table called ''customer'' with 0 rows (i.e. no data has been entered into the database yet). You have now completed the creation of a database and a table.

<hr>

<table border="0" cellspacing="0" width="100%">