Creating a database

[cheeseboy]

Hi, im new to mysql 🙂 so could somebody please tell me how to create a new database?

Thx

[Roger_Ramjet]

Start by reading some articles on database normalisation and database design, there are several here int the articles section. Then come back with a meaningfull question.

[Roger_Ramjet]

Or if you want the real answer to the question that you asked:

CREATE DATABASE [IF NOT EXISTS] db_name
[create_specification [, create_specification] ...]

create_specification:
[DEFAULT] CHARACTER SET charset_name
| [DEFAULT] COLLATE collation_name

CREATE DATABASE creates a database with the given name. To use CREATE DATABASE, you need the CREATE privilege on the database.