Commands to Create a MySQL DB?

[nickk]

doh, thought you said how to create a table,
to create a db just type 'CREATE DATABASE [dbname]' once you logged into mysql.

to create a table:

you have to login to mysql first:
mysql -u [username] -p
it'll ask your for your pass
then, type: use [databasename];

then something of this sort to create the database:
CREATE TABLE [table name]
(
ID INT AUTO_INCREMENT,
name VARCHAR(35) NOT NULL,
name2 int,
name3 date,
name4 text,

PRIMARY KEY (ID)
);

where name,name2... are variables of your choice, and int,date,varchar,text are variable types.