Changes

Creating New Databases and Tables with MySQL Administrator

604 bytes added, 19:22, 27 September 2007
Creating a New Database
[[image:mysql_admin_catalog.jpg]]
 
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.
 
The columns in the table may be viewed and modified by selecting the desired table in the list and clicking the ''Edit Table'' button.