Newbie! Help! How 2 create table???

I have to create a table with the following details:

# CREATE TABLE EGuest (
# num int(11) NOT NULL auto_increment,
# fullname text NOT NULL,
# email text NOT NULL,
# uin text,
# homepage text,
# location text,
# comment text NOT NULL,
# date text NOT NULL,
# PRIMARY KEY (num)

I'm using PHPMyADMIN and the only fields are:
Field Type Length/Set Attributes.

How do I set auto-increment and primary key & all the rest of the fields?

I have tried to read-up on this but remain very confused

Any help is much appreciated!

hothoundz,

I don't quite understand what you are asking for but I will try to answer what I think you are asking. (I think you want to know how to set up the table!????)

1. Make sure you have actually created a db
---create database [dbName]
2. You have to be using the a db to make a table
---use [dbName]
3. Create your table
---create table EGuest(num int(11) auto_increment not null, fullname varchar(50) not null, email varchar(50) not null, uin varchar(255), homepage varchar(255), location varchar(255), comment varchar(255) not null, date date not null, primary key(num));

That should do it. Once you are finished you can "look" at the db by--descrbie EGuest;

Also go and check out http://www.mysql.com/doc/ and also go to the mysql discussion boards on this site and read some of the q/a to help yourself. Doing this is very useful.

Later,
oach

Excellent - thanks! I'll get on to it.