rtfm.
Excerpt from mySQL manual.
=====================================================================
6.5.1 CREATE DATABASE Syntax
CREATE DATABASE [IF NOT EXISTS] db_name
CREATE DATABASE creates a database with the given name. Rules for allowable
database
names are given in Section 6.1.2 [Legal names], page 358. An error occurs if
the database already exists and you didn't specify IF NOT EXISTS.
Databases in MySQL are implemented as directories containing files that
correspond to tables in the database. Because there are no tables in a
database when it is initially created, the CREATE DATABASE statement only
creates a directory under the MySQL data directory.
You can also create databases with mysqladmin. See Section 4.8 [Client-Side
Scripts],
page 279.
=====================================================================
> -----Original Message-----
> From: Rosyna [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 23, 2001 8:55 PM
> To: [EMAIL PROTECTED]
> Subject: Creating Databases
>
>
> Does mySQL not support this syntax?
>
> CREATE DATABASE newDB ON
> (
> NAME = 'newDB',
> FILENAME = '~/newDB.mdf',
> SIZE = 10MB,
> MAXSIZE = 20MB,
> FILEGROWTH = 1MB )
> --
> Sincerely,
> Rosyna Keller
> Technical Support/Holy Knight/Always needs a hug
>
> Unsanity: Unsane Tools for Insane People
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
