Changes

Creating New Databases and Tables with MySQL Administrator

332 bytes added, 20:35, 27 September 2007
Creating New Tables
<pre>
CREATE TABLE `myDBase`.`customer` (
`customer_id` NUMERIC NOT NULL DEFAULT 0 AUTO_INCREMENT,
`customer_name` TEXT NOT NULL,
`customer_address` TEXT NOT NULL,
)
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 created of a database and a table.